Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-8492

IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 4.15.0, Mindville - Pre Bundled, 4.17.0, 4.16.0

      Issue Summary

      IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999

      Steps to Reproduce

      1. Create an object with a Date attribute.
      2. Set the value of the Date attribute to some date range 2042 to 9999. To make sure the year is registered as it is, enter the 4-digit year.
      3. Create another object with the date value in the past e.g. 12/12/2020
      4. After the creation of the objects, search with IQLs below with the attribute name replaced accordingly.
        "Expire Date" < now()
        
        "Expire Date" < -1d
        

      Expected Results

      The IQL is looking for objects with Expire Date in the past and hence, only the object with the past date (12/12/2020) in the result

      Actual Results

      Both objects show up in the result

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            [JSDSERVER-8492] IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999

            Marc Dacanay made changes -
            Labels New: ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 955292 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            Yinon Negev made changes -
            Link New: This issue relates to JRASERVER-77670 [ JRASERVER-77670 ]

            I have the same issue, that is impacting our organization !

            Olivier Adline added a comment - I have the same issue, that is impacting our organization !
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS New: 1

              Unassigned Unassigned
              michin Michelle Chin
              Affected customers:
              8 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated: