In which JIRA table jql for filter is stored

Question

Hi,

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

Francisco Morgado Gonzalez · Answer

Hi,

The field "REQCONTENT" has the JQL in searchrequest  table

Nic Brough -Adaptavist- · Answer

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!