Hi,
In searchrequest table exists the filter name and etc... but where is the sql query stored?
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.