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

Running a JQL search which contains many characters in the AQL or has many contexts returns no results

XMLWordPrintable

      Issue Summary

      When performing a JQL search that contains many characters in the AQL (aqlFunction()) or the Assets Custom Field has many contexts set up can cause no results to be returned.

      Steps to Reproduce

      1. Navigate to the Issue Search (Filters > View all issues)
      2. Enter in some JQL which contains many characters in the AQL e.g:
      3. "Assets Field" IN aqlFunction("Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A")
      1. No results will be returned
      2. Re run the same query with less characters in the AQL e.g:
      3. "Assets Field" IN aqlFunction("Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A OR Label Like A Or Label Like A")
      1. Results will be returned

      Expected Results

      The issue search results of the JQL are returned correctly.

      Actual Results

      The issue search will return "No issues were found matching your search"

      Workaround

      Reduce the number of contexts (remove if unused or group matching together) on the field or the complexity of the AQL used.

            [JSDCLOUD-14367] Running a JQL search which contains many characters in the AQL or has many contexts returns no results

            Richard Wang added a comment -

            Hi Everyone,

            This is Richard from the Assets team. We have some positive news regarding a solution. We have now rolled out a fix for this issue.

            Thank you for your patience.

            Best,

            Richard

            Richard Wang added a comment - Hi Everyone, This is Richard from the Assets team. We have some positive news regarding a solution. We have now rolled out a fix for this issue. Thank you for your patience. Best, Richard

              Unassigned Unassigned
              25f283676c22 Luke Muller
              Affected customers:
              4 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: