This article explains how to verify and troubleshoot errors in JQL queries when creating a report, modifying its source, or adding a JQL Post Filter.
How can you verify a source using a JQL query?
Whether you create a report from the Create New Report pop-up on the Manage Pivot Reports page or edit the source from the report sidebar, follow these steps to verify JQL search results:
-
Verify that the Source type is set to JQL / Search results.
-
Enter the JQL query to be used in the report.
-
Verify which checkmark appears:
If the query is valid, a green checkmark appears. No other action is required, and you can skip the remaining steps.
If the query is invalid, a red checkmark appears.
-
If the query is invalid, click Search.
-
Troubleshoot the query using Basic or Advanced JQL search modes in the Issue Navigator.
-
After the errors no longer appear in the Issue Navigator, copy the JQL query from Advanced JQL search mode back to the report.
-
Click Save and Reload.
Repeat these steps when troubleshooting a JQL Post Filter after entering a query in the Related issues section of the Source tab in the report sidebar.
How can you switch to Basic or Advanced search?
In the Issue Navigator, you can switch between Basic and Advanced (JQL) search modes.
If Basic mode is selected, click JQL to switch to Advanced mode.
If Advanced (JQL) mode is selected, click Basic to switch back.
On Data Center, the Basic option appears only when ‘JQL’ is selected. On Cloud, both options are visible at all times.
For more details on using Basic / Advanced search for Cloud and Basic / Advanced search for Data Center, refer to Atlassian's documentation.
How can you troubleshoot edge cases?
Private Project
The error message above appears when you no longer have access to a project referenced in a JQL query.
Contact a Project admin or Jira admin to request access.
Nested filters
The error message above appears when you no longer have access to a nested filter referenced in the JQL query.
Contact a Jira admin to request Viewer access, Editor access, or both.
Missing issues
If you suspect that some issues are missing from the Issue Navigator search results while no errors appear, contact a Jira admin to verify that you have permission to view all issue in the project, including issues restricted by an Issue Security Scheme.
For example, you may only see issues assigned to you and not all issues in a project, as described in the related article.
Unbound query
The error message above appears when you use an unbound JQL query in a report source. It can appear even when the query is valid, as indicated by the displayed green checkmark.
Refer to the related article to troubleshoot this error.
Archived Project
The error message above appears when a JQL query points to an archived project. Even if you previously had permission to access the project, archived projects are excluded from search results.
Request that a Jira admin unarchive the project.
Deleted issue
The error message above appears when a JQL query points to a deleted issue in a project that you have permission to access.
While you can access other issues in this project, deleted issues cannot be restored natively in Jira.
If you have questions or need assistance, contact our support team via email or service desk. Our team is available Monday through Friday (9:00 AM to 7:00 PM GMT+7) to help with technical challenges or discuss improvements.