In which JIRA table jql for filter is stored

Hi,

In searchrequest table exists the filter name and etc... but where is the sql query stored?

2 answers

Community moderators have prevented the ability to post new answers.

1 vote

It isn't. JIRA doesn't keep the SQL. In fact, it doesn't use SQL in searches at all, it reads the Lucene index for them.

The JQL for a search is stored in, well, Searchrequest.

As a random example from one of my systems, a line from searchrequest says

10109,'Filter for Scrum: Nics project','nic',NULL,'nic',NULL,NULL,'project = "Nic Test" ORDER BY Rank ASC',0,'filter for scrum: nics project'

Note the field in bold!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

Hi,

The field "REQCONTENT" has the JQL in searchrequest table

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.