SQL Query to get all values of version field

Soporte Ferrovial

Hello,

We've already asked the question directly to Atlassian support but they suggested that I tried Answers instead. 

We would need to obtain all the values registered in JIRA for the field VERSION. 

Futhermore we need to obtain all the values of the summary field of an specifiq project. What would be the jql query?

Thank you,

 

 

 

Piotr Bojko

It is not possible with JQL, but using ie this addon https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview

 

you would have SQL console with builtin permissions for data (just like in Jira) and you can query like this.

 

SELECT * FROM PROJECTVERSIONS