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

Insight IQL functions related to date comparison returns incorrect results for dates over 2044.

XMLWordPrintable

      Issue Summary

      IQL function that are used for date comparisons like now() , endOfYear() returns incorrect results for dates over 2044.

      Steps to Reproduce

      1. Create a new objectType (License) and include an attribute with the type 'Default' and  Type value 'Date'.
      2. Create a new object and enter the date value as '10/Oct/2044'
      3. Save it.
      4. Open the IQL view, and run the query to get all objects with dates less than now() 
      5. objectType = License and "End Date" < now()

      Expected Results

      IQL should not return the objects with "End Date" greater than the current date.

      Actual Results

      IQL returns the objects with "End Date" from the year 2044 too. But if you change the date to 2041. Then it is working as expected and not returning the objects.

      Workaround

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

        1. IQL_showing_incorrect_results_with_function_now.png
          70 kB
          Sireesha

            [JSDSERVER-11990] Insight IQL functions related to date comparison returns incorrect results for dates over 2044.

            Satej Mirpagar made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Mingyi Yang made changes -
            Status Original: In Review [ 10051 ] New: Waiting for Release [ 12075 ]
            Mingyi Yang made changes -
            Fix Version/s New: 10.2.0 [ 109023 ]
            Mingyi Yang made changes -
            Status Original: In Progress [ 3 ] New: In Review [ 10051 ]
            Mingyi Yang made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 957989 ]
            Mingyi Yang made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 957673 ]
            Mingyi Yang made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 954662 ]
            Marc Dacanay made changes -
            Labels New: ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 955659 ]
            Mingyi Yang made changes -
            Status Original: Gathering Impact [ 12072 ] New: In Progress [ 3 ]

              4efd9de64ab4 Mingyi Yang
              1463fcb5e3fd Sireesha
              Affected customers:
              5 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: