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

JQL queries that vary by day of the week

    XMLWordPrintable

Details

    • 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.

    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

          is duplicated by

          Suggestion - JRASERVER-27254 JQL function to return start of last working day

          • Closed
          relates to

          Suggestion - JRACLOUD-27539 JQL queries that vary by day of the week

          • Gathering Interest

          Activity

            People

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

              Dates

                Created:
                Updated: