AQL filter using date/datetime returning all assets for JSM DC 21.3.4

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 11.3.4
    • None
    • Severity 3 - Minor

      Issue Summary

      When using an AQL filter to try and filter assets by date/datetime in JSM DC 21.3.4 it returns all assets.

      Steps to Reproduce

      1. L&F datetime/date has to be set to one of the below in the "break" section
      2. Using either a new attribute in an asset that is of datetime/date create two new assets.
      3. One asset has a datetime of a time in January, one has a datetime in April
      4. Use AQL to filter based on a datetime/date field. e.g "datetime field" >= now(-30d)
      5. This will return all assets, instead of the correctly filtered assets. 

       

      (Similar issue with the default fields of "Created" and "Updated")

      Working formats:
      dd/MMM/yyyy h:mm a
      dd/MMM/yyyy hh:mm a
      dd/MMMM/yyyy h:mm a

      Formats that don't work:
      dd/MMM/yy h:mm a (default)
      EEEE, MMMM dd, yyyy h:mm:ss a
      yyyy-MM-dd HH:mm
      dd/MMM/yyyy h:mm:ss a
      MMMM dd, yyyy h:mm a
      dd-MMM-yyyy h:mm a

      Expected Results

      • It should return just the April asset, the one that has the datetime value within the last 30 days 

        Actual Results

      • Returns all assets.

      Workaround

      On the L&F (/secure/admin/LookAndFeel!default.jspa) adjust the value of Complete Date/Time Format to be one of the Working formats cited above.

      Versions Tested

      Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below: 

      Testing Requirements Version Affected Version
      Customers Reported Version 11.3.4 Yes
      Most Recent Bug-Fix Release    
      Previous Major Release    
      Most Recent LTS    
      Previous Supported LTS    
      Other Versions.. 10.3.18 No
      (Add rows as needed)    

              Assignee:
              Unassigned
              Reporter:
              Nick Austen
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: