Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-27254

JQL function to return start of last working day

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? 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 - JRACLOUD-27539 JQL queries that vary by day of the week

          • Gathering Interest
          is related to

          Suggestion - JRASERVER-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:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: