JQL query

[Roy Chapman]

A user has two fields in their project, "Environment Name" and "Date Deployed to Live".  They want to select the latest date for each Environment Name.  Any pointers?

[Nic Brough -Adaptavist-]

JQL won't do that, it's for getting a list of issues, not retreiving or reporting on their data.

But, in the issue navigator, you can just search for "Date deployed to live is not empty order by date deployed to live desc" and it'll give you a list of issues, with the first one being the latest.

[Roy Chapman]

Thanks Nic, this is what I suspected.  For now we will have to extract the issues into Excel and report from there.