It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL query

Roy Chapman May 24, 2017

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?

1 answer

0 votes
Nic Brough [Adaptavist] Community Leader May 24, 2017

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 May 25, 2017

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

9,319 views 30 42
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you