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

JQL queries that vary by day of the week

    XMLWordPrintable

    Details

    • UIS:
      66
    • Support reference count:
      5
    • Feedback Policy:
      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.

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              davidparks21 David Parks
              Votes:
              299 Vote for this issue
              Watchers:
              109 Start watching this issue

                Dates

                Created:
                Updated: