Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

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
hiddentrue

JQL search allows you to search for issues by the grid's content.

...

Table of Contents
maxLevel2
minLevel2

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:

issue in grids("Grid 1", "Column 1 = <search value>")



Panel
borderColorgrey
borderWidth2
titleSearch query syntax
issue in grids("<grid custom field name>", "<column name> <operator> <search value>")

search Search by 2 parameters:

Panel
borderColorgrey
borderWidth2
titleSearch query syntax
issue in grids("<grid custom field name>", "<column name> <operator> <search value>","<column name> <operator> <search value>")

search Search by 2 parametersgrids:

Panel
borderColorgrey
borderWidth2
titleSearch query syntax
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 typeSupported 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 

in

Checkbox=, ; !=, ; in, ; not in
Userlist=; !=; in; not in
Formula=, ; !=, ; in, ; not in in


Examples

Search issues by empty grids

...