This page describes JQL functionality in the Table Grid Next Generation.
...
Syntax
Use IN GRID GRIDS 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 gridgrids("<grid custom field name>", "<column name> <operator> <search value>") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | Search query syntax |
|---|
|
issue in gridgrids("<grid custom field name>", "<column name> <operator> <search value>","<column name> <operator> <search value>") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
| title | Search query syntax |
|---|
|
issue in gridgrids("<grid custom field name>", "<column name> <operator> <search value>") and issue in grid("<grid custom field name>", "<column name> <operator> <search value>") |
...
| 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 |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids(Checklist, "Summary~Onboarding") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids("Shopping order", "What sandwich=Chicken") |
...
Find all issues which have grid Testing with the column Summary that equals test and task;
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids("Testing", "Summary=test", "Summary=task", "status='open'") AND issue in grid("Grid2", "Summary=task") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids("Checklist", "Done=true") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids("Checklist", "Done=false") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
issue in gridgrids("Shopping order", "Price>10") |
...
| Panel |
|---|
| borderColor | grey |
|---|
| borderWidth | 2 |
|---|
|
| issue in gridgrids("Team Workload", "Team=Sales") |
...