This page describes JQL functionality in the Table Grid Next Generation.
...
| 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 | ||||
|---|---|---|---|---|
| ||||
issue in grids("Checklist", "Summary~Onboarding") |
Find all issues which have grid Shopping order with the column What sandwich that includes text Chicken
| Panel | ||||
|---|---|---|---|---|
| ||||
issue in grids("Shopping order", "What sandwich=Chicken") |
Find all issues which have grid Testing with the column Summary that equals test and task;
| Panel | ||||
|---|---|---|---|---|
| ||||
issue in grids("Testing", "Summary=test", "Summary=task", "status='open'") AND issue in grid("Grid2", "Summary=task") |
...
| Panel | ||||
|---|---|---|---|---|
| ||||
issue in grids("Checklist", "Done=true") |
Find all issues with the Checklist grid which have checkbox column and values are unchecked.
...
| Panel | ||||
|---|---|---|---|---|
| ||||
| issue in grids("Team Workload", "Team=Sales") |
