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

Add timezone support to JQL dates.

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • JQL
    • None
    • 7
    • 1
    • 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

      We should look at adding timezone support to dates. This would allow the users to create dates that were consistent no matter where they are run. The main change will be to JQLDateSupport.ACCEPTED_FORMATS and the tests.

      For example: 2008/09/12 GMT.Add time

      Here is my scenario. We have Shift 1 in India and Shift 2 in USA. I write a query to find all tickets that are still open to let Shift 2 take over. When a Shift 1 person gives that query to a Shift 2 person it is 12.5 hours into the past, and is useless.

      But if I could include a timezone, or at least specify to use server time zone that would fix it.

      Copy of JRASERVER-59615

      Here is my example query:

      project = "Security Incidents" AND status was in ("Create", Detect, "In Progress",Analysis) during ("2018/11/27 18:30", "2018/11/28 02:30") AND "Assignment Group" in (Tier-1, Tier-2) AND status was not in (Closed,Validated) DURING ("2018/11/27 18:30", "2018/11/28 02:30")

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              100b3090-04c9-4d3b-a4b7-a79f7dde320e Deleted Account (Inactive)
              Votes:
              56 Vote for this issue
              Watchers:
              40 Start watching this issue

              Dates

                Created:
                Updated: