IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
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.

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            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.

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

                          Created:
                          Updated:

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

                              Created:
                              Updated: