-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Affects Version/s: 11.3.4, 11.3.5, 11.3.6, 11.3.7, 11.3.8, 10.3.22
-
Component/s: Assets - IQL and Object Search
-
None
-
2
-
Severity 3 - Minor
-
5
Issue Summary
v11.3.4-11.3.8
When an Assets custom Date (or Date/Time) attribute is filtered with AQL comparison operators (=, <, >, <=, >=, or a range), the query returns incorrect results — no objects for equality/less-than/range queries, and all objects for greater-than queries — whenever the Jira Look & Feel "Complete Date/Time Format" is configured with a 2-digit year (e.g. dd/MMM/yy).
Steps to Reproduce
- In Admin → System → Look and Feel, set the Complete Date/Time Format to a 2-digit-year pattern, e.g. dd/MMM/yy h:mm a.
- Create an Assets object type (e.g. Month) with a custom Date attribute named Start.
- Create objects with these Start values: 2026-06-01, 2026-07-01, 2026-08-01.
- Run this AQL query (Assets → object search or IQL):
objectType = Month AND "Period Start" >= "2026-06-22" AND "Period Start" <= "2026-07-25"
Expected Results
1 object
Actual Results
0 objects
Workaround
Use a 4-digit-year Look & Feel format (yyyy)
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-11.3.8 | yes |
| Most Recent Bug-Fix Release | ||
| Previous Major Release | ||
| Most Recent LTS | ||
| Previous Supported LTS | ||
| Other Versions.. | ||
| (Add rows as needed) |
- is related to
-
JSDSERVER-16549 AQL filter using date/datetime returning all/none assets for JSM DC 11.3.4
-
- Closed
-