Convert JQL to SQL

Question

Hi,

I want to convert JQL query used on Jira to SQL.

The Jql filter used is :

project = code AND resolved > startOfWeek(-1w) AND resolved < startOfWeek() AND fixVersion <= code ORDER BY status DESC, resolved ASC"

Anyone know how to convert that in SQL and how to know in which table on database the fields "resolved", "fix version", "affect versions" exists.

Contact Kintosoft · Answer

You might want to have a look at the SQL+JQL Driver plugin as it allows such kind of transformations of JQL into SQL in a straightforward way, BUT the conversion is not for the Jira native database space.

Mohamed Benziane · Answer

Hi @Anis Ben Romdhane

For me, resolved will be in jiraissue called "RESOLUTIONDATE" for the other table you can take a look at this:

https://confluence.atlassian.com/display/JIRA041/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindFixedForversionsforanissue

Regards