nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for spreadsheets - How can I get the fixVersion release date value?

tal-yechye

Hello guys,

In the releases view we see in the table a column of the fixVersion, and also the column of "Release date".

How can I get the value of the "Release date"?

I tried the following fields but non of them is valid:

releaseDate

releasedate

and more

As an alternative, can I get this value?

Regards.

P.S.

I now suspect it is a custom field. Is it?

Accepted answers

Nic Brough -Adaptavist-

JQL returns issues, not versions. When you run JQL, all it does is return a list of issues, which your reporting method can then iterate through and pull out the issue data it wants to see.

The dates on versions are not issue data, so the results of JQL won't contain them. You'll need extra code to go fetch them independently of the JQL, over the REST interface.

All comments

Nic Brough -Adaptavist-

JQL returns issues, not versions. When you run JQL, all it does is return a list of issues, which your reporting method can then iterate through and pull out the issue data it wants to see.

The dates on versions are not issue data, so the results of JQL won't contain them. You'll need extra code to go fetch them independently of the JQL, over the REST interface.

tal-yechye

Nic, I accept you answer of course.

Thank you.

But if I use REST API, how do I integrate it into the spreadsheet?

Nic Brough -Adaptavist-

The coding you are doing in the spreadsheet can be made to do REST calls to fetch data.

Gerda Grantiņa _ eazyBI

Hi @tal-yechye ,

If you are looking at how to make reports about your version release date, you may want to explore the "eazyBI for Jira" app with a native Jira integration.
Here is a demo report for Version releases in the Gantt chart that uses "Version release date": https://eazybi.com/accounts/1000/cubes/Issues/reports/754436-fix-version-release-gantt-chart

Version releases in eazyBI.jpg

best,
Gerda // support@eazyBI.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud