-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 11.3.4
-
Component/s: Jira Service Management
-
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
- L&F datetime/date has to be set to one of the below in the "break" section
- Using either a new attribute in an asset that is of datetime/date create two new assets.
- One asset has a datetime of a time in January, one has a datetime in April
- Use AQL to filter based on a datetime/date field. e.g "datetime field" >= now(-30d)
- 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) |