This page describes JQL functionality in the #Table Table Grid Field#Next Generation.
| Excerpt |
|---|
|
JQL search allows you to search for issues by the grid's content. |
You can refer to the table grid data with the help of Jira advanced search. The query returns all issues having a grid with the specified data.
Table Grid Next Generation is configured to index grid columns by default starting from 1.3.0 version.
| Note |
|---|
If the grid was created in earlier versions 1.20 or lower, you should manually set columns indexing in the configuration. |
starting from
Syntax
Use IN GRID as a JQL function to search by the grid's content. Check the syntax below.
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | Search query syntax |
|---|
|
issue in grid("<grid custom field name>", "<column name> <operator> <search value>") |
search by 2 parameters
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | Search query syntax |
|---|
|
issue in grid("<grid custom field name>", "<column name> <operator> <search value>","<column name> <operator> <search value>") |
search by 2 parameters
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | Search query syntax |
|---|
|
issue in grid("<grid custom field name>", "<column name> <operator> <search value>") and issue in grid("<grid custom field name>", "<column name> <operator> <search value>") |
| Warning |
|---|
All search values are case sensitive. You need to specify it in the same case as it is inside the grid. |
Reference
Below you find a detailed description of the operators that are used for advanced searching within the grid's content. Each column type supports a set of the operators detailed in the table below.
| Column type | Supported operators |
|---|
| String, Textarea | ~, !~, =, !=, in, not in |
| Integer, Number | =, !=, in, not in, <, <=, >, >= |
| Date, Time, DateTime | =, !=, in, not in, <, <=, >, >= |
| Single Select List, Multi Select List | =, !=, in, not in |
| Checkbox | =, !=, in, not in |
| Userlist | =, !=, in, not in |
Examples
Search issues by empty grids
You can search for issues by the GRID_NAME and whether the grid has some data or not.
...
all issues which contain a grid that is empty or is not empty. The grid is considered empty when it has not been modified.
Check the examples below.
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | JQL query example |
|---|
|
"Grid 1" IS NOT EMPTY |
info |
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | JQL search helper query format |
|---|
| The format of the query in JQL search helper is following: "GRID_NAME" <operator> <keywords> |
"Grid 1" IS EMPTY |
Search issues by data from the grid
Find all issues which have gird Checklist with a column called Summary and text Onboarding
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid(Checklist, "Summary~Onboarding") |
Image Added
Find all issues which have grid Shopping order with the column What sandwich that includes text Chicken
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid("Shopping order", "What sandwich=Chicken") |
Image Added
Find all issues which have grid Testing with the column Summary that equals test and task;
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid("Testing", "Summary=test", "Summary=task", "status='open'") AND issue in grid("Grid2", "Summary=task") |
Find all issues which have grid Checklist with the checked checkboxes(column name is Done; checked checkbox equals true)
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid("Checklist", "Done=true") |
Image Added
Find all issues with the Checklist grid which have checkbox column and values are unchecked.
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid("Checklist", "Done=false") |
Find all issues which have grid Shopping order with the Price greater than 10
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in grid("Shopping order", "Price>10") |
Find all issues with Team Workload grid which includes Sales team data. The query helps to find all the workload for a specific team.
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
| issue in grid("Team Workload", "Team=Sales") |
Image Added