...
Style |
---|
code {
color: #c7254e;
background-color: #f9f2f4;
border-radius: 4px;
padding: 2px 2px;
} |
With JQL, you can search for specific issues by their grid values.
Excerpt | ||
---|---|---|
| ||
JQL search allows you to search for issues by the grid's content. |
...
Table of Contents | ||||
---|---|---|---|---|
|
Syntax
Use IN GRIDS as Use in grids
as a JQL function to search by the grid's content. Check the syntax below.
Note |
---|
All search values are case sensitive. So, if you have a grid named Grid1 with a column named Column 1, the query and column name in your search query should look like this:
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
issue in grids("<grid custom field name>", "<column name> <operator> <search value>") |
search Search by 2 parameters:
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
issue in grids("<grid custom field name>", "<column name> <operator> <search value>","<column name> <operator> <search value>") |
search Search by 2 parametersgrids:
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>") |
Warning |
---|
All search values are case sensitive. You need to specify it in the same case as it is inside the grid. |
Restricted words and characters
JQL search has a set of reserved characters:
...
surround them with quote-marks (you can use either single quote-marks (
'
) or double quote-marks ("
)). For example:Code Block issue in grids(“Grid quotes”, version = "[example]")
if you are searching a text and the character is on the list of reserved characters for text searches, surround them with two backslashes( \\ ). For example:
Code Block issue in grids(“Grid quotes”, ”Summary = \\[Jul 10]\\ - Invoice pending review”)
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 in |
Examples
Search issues by empty grids
...