Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Excerpt | ||
---|---|---|
| ||
You can search issue by grid data. |
Style |
---|
code {
color: #c7254e;
background-color: #f9f2f4;
border-radius: 4px
}
|
In this article we describe how to make a search with a JQL query in the Table Grid Editor for Jira Cloud.
With JQL you can search issues by entering data from the grid.
Note |
---|
You can make a search in a column only if the data in a column is indexed. To index data in a column check Index data checkbox when configuring a column. |
The search could be done by:
part of the text or the whole string in the list, user-list, string and textarea column types;
a number in the number and integer column types;
date, time, datetime in the date, time, and datetime column types.
You can search using JQL search helper pop-up. We've implemented code hints and inline validation to make constructing queries easy.
Search with the help pop-up
We've created a special button that helps to generate a query.
On the top right corner of the issue navigator page, find the plugin's icon that opens a help pop-up.
The JQL search helper will pop-up: Image Removed
![](https://tablegrid.atlassian.net/wiki/download/thumbnails/2228891/JQL%20pop%20up.png?version=1&modificationDate=1518087133756&cacheVersion=1&api=v2&width=639)
Start typing your query in the search box and get autosuggestions to build your query.
Info |
---|
JQL search helper query formatThe format of the query in JQL search helper is following: "GRID_NAME"."COLUMN_TITLE" <operator> "search value" You can use various JQL operators depending on the data format: |
Column type | Data format | Operator |
---|---|---|
Date, Time, DateTime | date |
|
UserList, String, Formula, TextArea, Sequence | text |
|
SingleSelect | string |
|
Number, Integer | number |
|
Info |
---|
![](https://tablegrid.atlassian.net/wiki/download/thumbnails/2228891/JQL%20grid.png?version=1&modificationDate=1518176399059&cacheVersion=1&api=v2&effects=drop-shadow&width=640)
![](https://tablegrid.atlassian.net/wiki/download/thumbnails/2228891/JQL%20grid.png?version=1&modificationDate=1518176399059&cacheVersion=1&api=v2&width=639)
Once the query is ready, click Submit button to see results. A separate page opens to show the search results.
Image Removed
Image Added
Please, check the example:Image Removed
![](https://tablegrid.atlassian.net/wiki/download/thumbnails/2228891/JQL.gif?version=1&modificationDate=1518176038518&cacheVersion=1&api=v2&width=639)
Also check out our guide how to set up and use JQL search.
Table of Contents |
---|