This page describes JQL functionality in the Table Grid Next Generation.
...
| 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:
| Code Block |
|---|
space (" ") + . , ; ? | * / % ^ $ # @ [ ] |
If you want to use these characters in your search queries, you need to
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 | ~, !~, =, !=, 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 |
...