JQL Query
The JQL query editor allows you to define the scope of work displayed in the table using a JQL query.
For detailed guidance on using JQL, see Jira’s JQL documentation.
How to use JQL Query
Login to your Jira Cloud site.
Select the project you want to manage with the Flexible Table app, following the instructions in the Getting Started guide.
The table view in Flexible Table will appear.
Click the Edit scope icon at the top right of the table view.
In the Edit scope screen, configure the range of work items using a JQL query.
Click Save to apply your changes.
JQL query editor
Expand/Collapse editor: Click Expand editor on the right of the query box to expand the input field. Click Collapse editor to close it again.
JQL query examples
Here are some examples of how you can extend the default query provided by the app.
View unresolved work by assignee (most recent first)
To focus on unresolved work items grouped by assignee and sorted by newest first, you can use:
In the JQL query editor, enter:
project = PCR AND resolution = EMPTY AND assignee IS NOT EMPTY ORDER BY createdDate DESC(Replace PCR with your actual project key.)
Add the Assignee field in Add system fields.
In Group by, select Assignee.
The table will then display unresolved work grouped by assignee and sorted in descending order by Created date.
Focus on high-priority unresolved work
To prioritize high-importance work that is still unresolved:
In the JQL query editor, enter:
project = PCR AND resolution = EMPTY AND priority IN (Highest, High) ORDER BY priority DESC, createdDate DESC(Replace PCR with your actual project key.)
Add the Priority field in Add system fields.
In Group by, select Priority.
The table will show unresolved work grouped by priority, with the highest priority and most recently created items at the top.