Versions Compared

Version Old Version 20 New Version Current
Changes made by

Oleksandr Borozenets (Deactivated)

Dam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Style
code {
    color: #c7254e;
    background-color: #f9f2f4;
    border-radius: 4px
}

This guide shows how to set up and use JQL search.

By default, JQL helps to search issues in Jira. With Table Grid, you can search issues by the content of a grid. You can search by the whole string, part of the text, date, time or number. 

Note

You can search data only for indexed columns. To index data in a column check the Index data checkbox when configuring a column.

Table of Contents

JQL search helper 

We've implemented a special button that helps you to search by the grid's content.

Click plugin's icon in the top right corner of the issue navigator page to open the JQL search helper.

Image Removed

Image Added
 The window pops up and you can type the query.

Tip

Make sure that pop-ups are not blocked form displaying in your browser settings.

Info

title

JQL search helper query format

The 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, and DateTime

date

= , != , > , >= , < , <=, IS , IS NOT , IN , NOT IN

UserList, String, Formula, TextArea,

Sequence 

Sequence 

text

~ , !~

SingleSelect

string

= , !=, IS, IS NOT, IN, NOT IN

Number,

 Integer 

 Integer 

number

= , != , > , >= , <, <=, IS , IS NOT, IN , NOT IN

Info

The query starts with "GRID NAME"."COLUMN_TITLE" ...

 As COLUMN

 As you type, Jira will offer a list of "auto-complete" suggestions based on the context of your query.

Image Modified

The query looks like this:

Image Modified

This query will find issues with the status 'Open' in Grid2.  Where Grid2 is "GRID NAME"; Statusis

 

 COLUMN_TITLE; = is an operator and Open is a search value.

Note

Grid default data and data from an external data source is not indexed until you re-save grid from the issue view.

Check an example below. It shows how to search by the column value, located in the grid.

Image Modified

Congratulations! Now you know how to set up and use JQL to search by the grid's column content.  

toc