...
| Note |
|---|
If the grid was created in earlier versions 1.20 or lower, you should manually set columns indexing in the configuration. |
| Note |
|---|
To make a column searchable you need to check the Index data checkbox when configuring a column. |
| Table of Contents | ||||
|---|---|---|---|---|
|
Syntax
Use in grids as a JQL function to search by the grid's content. Check the syntax below.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
issue in grids("<grid custom field name>", "<column name> <operator> <search value>") and issue in grid("<grid custom field name>", "<column name> <operator> <search value>") |
Restricted words and characters
JQL search has a set of reserved characters:
...
You can't search for many special characters in text fields using this method.
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 |
|
| Integer, Number |
|
| Date, Time, DateTime |
|
| Single Select List, Multi Select List |
|
| Checkbox | =; !=; in; not in |
| Userlist | =; !=; in; not in |
| Formula | =; !=; in; not in |
Examples
Search issues by empty grids
You can search for all issues which contain a grid that is empty or is not empty. The grid is considered empty when it has not been modified.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
"Grid 1" IS EMPTY |
Search issues by data from the grid
Find all issues which have grid Checklist with a column called Summary and text Onboarding
...