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.
Dates:
Search for date columns by using the following syntax:
"Demo Table" >= "Date{2020-10-05}"
"Demo Table" >= "Date{now()}"
"Demo Table" <= "Date{-3d}"
The most common operators and functions are supported.
=, >, <, >=, <=,
now()
endOfDay
EndOfWeek
endOfMonth
endOfYear
startOfDay
startOfWeek
startOfMonth
startOfYear
+- w/d/h/m