Convert JQL to SQL

[Anis Ben Romdhane]

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.

[Mohamed Benziane]

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

[Pablo Beltran]

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.