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

JQL function to return start of last working day

    XMLWordPrintable

Details

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

      As a user, I want to search for issues that were in progress on the last working day, to provide context for my team's daily stand-up meeting.

      Currently the best I can do with JQL is "status WAS IN ("In Progress") AFTER startOfDay(-1)", which does not work on a Monday because the last working day was 3 days ago.

      I therefore want a "startOfLastWorkingDay()" function to return the start of the last working day. When called on a Monday, it would return the start of the preceding Friday. It should also skip over registered non-working holidays.

      Alternatively, I want a "-1wd" syntax to subtract working days from the date, such that startOfDay("-1wd") executed on a Monday returns the start of the previous Friday.

      Attachments

        Issue Links

          duplicates

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

          • Gathering Interest
          relates to

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

          • Closed

          Activity

            People

              Unassigned Unassigned
              0d7677977624 Graham Poulter
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: