Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-27539

JQL queries that vary by day of the week

XMLWordPrintable

    • 8
    • 5
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      JQL needs something like:

      now()=='Friday'

      Use case:
      As an Agile/Scrum/GreenHopper user we have an Agile project dashboard including a query for what we completed yesterday and what's assigned to us now.

      This quick view is used extensively in the daily stand-up meetings where we normally present yesterdays work and current work.

      This view fails us on Monday, as past day doesn't include friday or the occasional weekend work.

      We can't use two queries because the dashboard views don't support such a thing.

      We need a way for this query to work differently depending on the current day/time so that it can effectively be used in dashboard views.

      Having a startOfDay(-1, 'BusinessDaysOnly') feature would be another solution to the problem.

            [JRASERVER-27539] JQL queries that vary by day of the week

            Cao, Nghia Chi added a comment -

            I would like to have this feature too with exactly same needs as stated by the author.

            Cao, Nghia Chi added a comment - I would like to have this feature too with exactly same needs as stated by the author.

            Lucas Laurindo dos Santos added a comment -

            Thanks @Frank Sarubbi for you comment (6 years ago!), seems to work fine. Here's a slightly improved version using start of the day:

            (status CHANGED AFTER startOfDay(-1d) OR status CHANGED DURING (startOfDay(-3d), endOfWeek(-1w)))

            Lucas Laurindo dos Santos added a comment - Thanks @Frank Sarubbi for you comment (6 years ago!), seems to work fine. Here's a slightly improved version using start of the day: (status CHANGED AFTER startOfDay(-1d) OR status CHANGED DURING (startOfDay(-3d), endOfWeek(-1w)))

            Kenzie Osfield added a comment -

            Hello

            Is there any movement on this feature? I am looking to set up gadgets for service desks that allows me to show and filter cases in particular status' closed between Monday to Friday.

            Kenzie Osfield added a comment - Hello Is there any movement on this feature? I am looking to set up gadgets for service desks that allows me to show and filter cases in particular status' closed between Monday to Friday.

            Ricardo Bastiaan added a comment -

            Hi All,
            I am quite new to Jira., but I was wondering.
            How does this relate to reports that now include weekends in the graphs?
            For example we have resolved tickets, but when we create a report it includes the weekends.
            The effect is that you see 5-days where tickets are resolved and 2 days nothing.
            It doesn't give a proper view of the amount of tickets closed.

            Ricardo Bastiaan added a comment - Hi All, I am quite new to Jira., but I was wondering. How does this relate to reports that now include weekends in the graphs? For example we have resolved tickets, but when we create a report it includes the weekends. The effect is that you see 5-days where tickets are resolved and 2 days nothing. It doesn't give a proper view of the amount of tickets closed.

            Farbod Ziaee added a comment -

            Is there a way to get this feature in place? 

            Farbod Ziaee added a comment - Is there a way to get this feature in place? 

            Domenico Manzo [Actonic] added a comment -

            @Rachid Chaoua, you may try "Power JQL: extended search functions", this should solve this and other search issues:  https://marketplace.atlassian.com/1216891

            This Plugin give you Additional and useful JQL functions to search issues using the power of regex expressions! 

            Best Regards
            Domenico 

            Domenico Manzo [Actonic] added a comment - @Rachid Chaoua, you may try "Power JQL: extended search functions", this should solve this and other search issues:   https://marketplace.atlassian.com/1216891 This Plugin give you Additional and useful JQL functions to search issues using the power of regex expressions!  Best Regards Domenico 

            Rachid Chaoua added a comment -

            This feature request is 8 years old. Any chance maybe we could get it addressed? Paying customers would like to know.

            Rachid Chaoua added a comment - This feature request is 8 years old. Any chance maybe we could get it addressed? Paying customers would like to know.

            Siva Musuluri added a comment -

            We have a case where we need to exclude all weekends, while extracting a report for a Date range. It will help users to get an actual view on SLA or Time taken to resolve the issue/ticket.

            Siva Musuluri added a comment - We have a case where we need to exclude all weekends, while extracting a report for a Date range. It will help users to get an actual view on SLA or Time taken to resolve the issue/ticket.

            Alec Antrim added a comment -

            We have a case where we expect tickets to be resolved within 2 business days.  Please implement this in a way that allows us to count the number of weekdays since creation, so we don't artificially escalate tickets that are created at the end of the week.

            Alec Antrim added a comment - We have a case where we expect tickets to be resolved within 2 business days.  Please implement this in a way that allows us to count the number of weekdays since creation, so we don't artificially escalate tickets that are created at the end of the week.

            Domenico Manzo [Actonic] added a comment -

            Hi @all, 

            you may try "Power JQL: extended search functions", this should solve this and other search issues:  https://marketplace.atlassian.com/1216891

            This Plugin give you Additional and useful JQL functions to search issues using the power of regex expressions! 

            Best Regards
            Domenico 

            Domenico Manzo [Actonic] added a comment - Hi @all,  you may try "Power JQL: extended search functions", this should solve this and other search issues:   https://marketplace.atlassian.com/1216891 This Plugin give you Additional and useful JQL functions to search issues using the power of regex expressions!  Best Regards Domenico 

              Unassigned Unassigned
              davidparks21 David Parks
              Votes:
              371 Vote for this issue
              Watchers:
              122 Start watching this issue

                Created:
                Updated: