JQL Search

1 Single values
2 Multi-values
3 AND NOT IN
4 Formula
5 Dates
6 Supported operators and functions

Single values

You can use JQL to search for issues that have tables with certain content in defined columns.

The following JQL will show all issues that have the value "Services" in the Column "Element" of the table "Deal Positions".

"Deal Positions" = "Element{Services}"

Multi-values

Starting with version 1.0.31, we can now search for multiple values in one table row.

"Tablefield" = "Column1{value} [and] Column2{value}"

Example:
Omega = "Alfa{Jira} [and] Beta{10}"

The JQL above will return the issues where the values “Jira” and “10” show on the same row in the Omega table.

AND NOT IN

This is our custom JQL negative operator, which allows us to return issues where table columns do not contain certain values.

For example,

Checklist = "Assignee{currentUser()} [and IS NOT] Status{Done} [and IS NOT] Status{Open}"

will return tables with rows that have the current user selected in the ‘Assignee’ column AND anything but ‘Done' or ‘Open’ values in the ‘Status column’.

Formula

To look for formula-calculated values, search indexation must be enabled first.

To configure, go to Table configuration → Formula column → Manage → Index for search.

Enabling the search will make all new and updated later values available for search. A re-index must be completed first to look for values created before this opinion was enabled.

Example of a JQL query:

"Table Name" = "Formula Column Name{value}"

All values are stored exclusively in Jira’s database.

Dates

Search for date columns by using the following syntax:

Supported operators and functions

Column Type	Supported operators	Functions	Keywords

Column Type	Supported operators	Functions	Keywords
Simple Text	~ , !~ , is not , is		EMPTY
Unlimited text	not searchable	n/a	n/a
Number	= , != , <= , >= , > , < , is not , is , not in , in		EMPTY, ORDER BY (ASC / DESC)
Decimal Number	= , != , <= , >= , > , < , is not , is , not in , in		EMPTY, ORDER BY (ASC / DESC)
Select List	= , !=, is not , is , not in , in		ORDER BY (ASC / DESC), EMPTY
Status	= , != , is not , is , not in , in		EMPTY
User Picker	= , != , is not , is, not in, in		EMPTY, ORDER BY (ASC / DESC)
Checkbox	= , != , is not , is, not in, in		unchecked, ORDER BY (ASC / DESC)
Formula	= , != , <= , >= , > , < , is not , is , not in , in		EMPTY, ORDER BY (ASC / DESC)
Date	= , != , <= , >= , > , < , is not , is , not in , in	currentLogin(), endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear()	EMPTY, ORDER BY (ASC / DESC)