In which JIRA table jql for filter is stored

[Bob Bobinsy]

Hi,

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

[Nic Brough -Adaptavist-]

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!

[Francisco Morgado Gonzalez]

Hi, 

The field "REQCONTENT" has the JQL in searchrequest  table