Page tree
Skip to end of metadata
Go to start of metadata

This page describes JQL functionality in the Table Grid Next Generation. You can refer to the table grid data with the help of Jira advanced search. The query returns all issues having a grid with the specified data. 

Table Grid Next Generation is configured to index grid columns by default starting from 1.3.0 version.

If the grid was created in earlier versions 1.20 or lower, you should manually set columns indexing in the configuration.

 starting from

Syntax

Use IN GRID  as a JQL function to search by the grid's content. Check the syntax below.

Search query syntax
issue in grid("<grid custom field name>", "<column name> <operator> <search value>")

search by 2 parameters

Search query syntax
issue in grid("<grid custom field name>", "<column name> <operator> <search value>","<column name> <operator> <search value>")

search by 2 parameters

Search query syntax
issue in grid("<grid custom field name>", "<column name> <operator> <search value>") and issue in grid("<grid custom field name>", "<column name> <operator> <search value>")

All search values are case sensitive. You need to specify it in the same case as it is inside the grid.


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 
Checkbox=, !=, in, not in
Userlist=, !=, 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. 

Check the examples below.

JQL query example

"Grid 1" IS NOT EMPTY 

JQL query example

"Grid 1" IS EMPTY 

Search issues by data from the grid

Find all issues which have gird Checklist with a column called Summary and text Onboarding

issue in grid(Checklist, "Summary~Onboarding")

Find all issues which have grid Shopping order with the column What sandwich that includes text Chicken

issue in grid("Shopping order", "What sandwich=Chicken")



Find all issues which have grid Testing with the column Summary that equals test and task

issue in grid("Testing", "Summary=test", "Summary=task", "status='open'") AND issue in grid("Grid2", "Summary=task")

Find all issues which have grid Checklist with the checked checkboxes(column name is Done; checked checkbox equals true)

issue in grid("Checklist", "Done=true")

Find all issues with the Checklist grid which have checkbox column and values are unchecked.

issue in grid("Checklist", "Done=false")


Find all issues which have grid Shopping order with the Price greater than 10

issue in grid("Shopping order", "Price>10")

Find all issues with Team Workload grid which includes Sales team data. The query helps to find all the workload  for a specific team.

issue in grid("Team Workload", "Team=Sales")

  • No labels