Versions Compared

Old Version 15

changes.mady.by.user svitlana

Saved on

compared with

New Version Current

changes.mady.by.user Dam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

As far as you knowBy default, JQL helps to search issues in Jira. We've implemented issues search by the grid's contentWith 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. 

To search issues by the grid's data, you should set the grid's column to index data. In order to do that, please check the Index data checkbox in the column configuration. 

Info

To make the search issues by the grid's data, configure the column to index data.

How to set up index data

Prerequisites: configured grid with columns. 

In order to set up the column to index data, please do the following: 

  • Navigate to the Grids list (Add-ons - Grids);
  • Select desired Grid to edit
  • Click on the column to edit its settings;
  • Check the Index Data checkbox;
    • Save column and grid configuration changes.
    Note

    Data indexing in a grid will be performed only for configured columns. Please, be sure the column has Index Data checkbox checked.

    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>

    "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 

    text

    ~ , !~

    SingleSelect

    string

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

    Number, 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