Misasligned L&F date (or datetime) format and the datepicker format causes dates replaced as part of AQL placeholder replacement to not match any assets

XMLWordPrintable

    • Severity 3 - Minor

      Issue Summary

      Misaligned Look and Feel date ('Day/Month/Year Format') (or datetime - 'Complete Date/Time Format') format and the Jira Java datepicker format (Application Property: jira.date.picker.java.format) (or Jira Java date time picker format - Application Property: jira.date.time.picker.java.format) causes dates / datetimes replaced as part of AQL placeholder replacement to not match any assets (when assets attribute dates / datetimes should match)

      Steps to Reproduce

      • Adjust the Application property: jira.date.picker.java.format to have a four digit year (note: this is the default in 11.3.0)
      • Create a new empty assets object schema called 'test' and assets object type called 'testobject', which includes a new attribute of type datetime (date also causes the same problem)
      • Create two objects with two unique datetimes

      • Create a new project
      • Create an assets object custom field and configure it to query 'testobject' assets objects based on matching 'duedate' date values from the default 'duedate' custom field




      • In your new project, add your new assets custom field as a field on the default issue screen

      1. Use the Jira issue 'create' button, to begin creating a new issue and configure the 'duedate' field with a date matching that configured for the 'Test Object 1' assets object you created above

      • Open the 'test assets custom field' dropdown, to reveal matching results

      Actual Results

      No Assets objects are returned matching the 'duedate' value

      Expected Results

      Assets object ‘Test Object 1’ is returned as an AQL match

      Workaround

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

      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    
      Most Recent Bug-Fix Release    
      Previous Major Release    
      Most Recent LTS 11.3.0 No
      Previous Supported LTS 10.3.13 Yes
      Previous Supported LTS 5.12.29 Yes
      Other Versions.. 11.2.0 Yes
      (Add rows as needed)    

        1. image-2025-11-25-09-56-40-511.png
          image-2025-11-25-09-56-40-511.png
          56 kB
        2. image-2025-11-25-09-56-53-135.png
          image-2025-11-25-09-56-53-135.png
          49 kB
        3. image-2025-11-25-10-00-57-514.png
          image-2025-11-25-10-00-57-514.png
          53 kB
        4. image-2025-11-25-10-01-23-602.png
          image-2025-11-25-10-01-23-602.png
          167 kB
        5. image-2025-11-25-10-01-36-338.png
          image-2025-11-25-10-01-36-338.png
          96 kB
        6. image-2025-11-25-10-01-50-926.png
          image-2025-11-25-10-01-50-926.png
          188 kB
        7. image-2025-11-25-10-02-14-215.png
          image-2025-11-25-10-02-14-215.png
          106 kB
        8. image-2025-11-25-10-02-53-474.png
          image-2025-11-25-10-02-53-474.png
          188 kB
        9. image-2025-11-25-10-03-40-762.png
          image-2025-11-25-10-03-40-762.png
          132 kB
        10. image-2025-11-25-10-05-12-910.png
          image-2025-11-25-10-05-12-910.png
          51 kB
        11. image-2025-11-25-10-05-30-893.png
          image-2025-11-25-10-05-30-893.png
          37 kB
        12. image-2025-11-25-10-20-41-195.png
          image-2025-11-25-10-20-41-195.png
          105 kB
        13. image-2025-11-25-10-23-51-829.png
          image-2025-11-25-10-23-51-829.png
          10 kB
        14. image-2025-11-25-10-24-08-049.png
          image-2025-11-25-10-24-08-049.png
          26 kB
        15. image-2025-11-25-10-24-29-080.png
          image-2025-11-25-10-24-29-080.png
          22 kB

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

              Created:
              Updated: