Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Current »

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.

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.

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:

Data typeOperator
date

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

text

~ , !~

string

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

number

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

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

  • No labels