Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-17165

Asset AQL not working with "dateAttribute" <= or >= without using now ()

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • Assets - AQL
    • None

      Issue Summary

      Use Assets AQL to filter objects based on date attribute with  "equal or greater/less than" (>=/<=) operators

      Steps to Reproduce

      1. Create a Date attribute on an Object Type
      2. Create an object and store a date on it
      3. Try to do AQL search "Attribute" >= "Date"

      Expected Results

      Object is returned

      Actual Results

      No data returned . 

      Workaround

      Currently the workaround is use hours instead of date .Alternatively  use now() to fetch the result . For instance -

      "expiry" > now(30d)

       

        1. Screenshot 2025-07-08 at 4.27.09 PM.png
          136 kB
          Deepika Rai
        2. Screenshot 2025-07-08 at 4.27.23 PM.png
          201 kB
          Deepika Rai
        3. Screenshot 2025-09-08 at 1.16.43 PM.png
          116 kB
          Deepika Rai
        4. Screenshot 2025-09-08 at 1.16.43 PM-1.png
          116 kB
          Deepika Rai

              0cd340ddafee Shivek Pamnani
              32f8589c5889 Deepika Rai
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: