| 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:
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, DateTimedate | Date: 2024-02-27 DateTime: 2024-02-19 10:00 Time: 1970-01-01 13:00 *Jira don’t support searching by only time, so we will need to add prefix 1970-01-01 in this case |
|
UserList, String, Formula, TextArea, Sequence | text |
|
SingleSelect | string |
|
Number, Integer | number |
|
| Info |
|---|
Once the query is ready, click Submit button to see results. A separate page opens to show the search results.
Please, check the example:
Also check out our guide how to set up and use JQL search.
| Table of Contents |
|---|