Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

BUG JQL: Unable to query next-gen project's issues with status WAS 'statusName' Edited

When using JQL to search for issues in a next-gen project, it doesn't work to do :

project='PN' AND status WAS IN ('In Progress') DURING('2020-03-06','2020-03-08')

But if you rename the name of the In Progress status in your board (and change it in your query) it works.

Step to reproduce :

  1. Create a new next-gen product.
  2. Add issues
  3. Make one of the issues In Progress
  4. Query your project issues with query like above with todays date in during
  5. You will receive an empty response
  6. Go back in your next-gen project
  7. rename the In Progress column to 'In Prog'
  8. Query again changing the status name
  9. It works.


2 answers

1 accepted

3 votes
Answer accepted

Hi @Antoine Emond

This is a known bug, albeit not with all the specifics you mention - see JRACLOUD-72180. Worth adding them on there!

There is a workaround mentioned on this bug to search via Status ID rather than name - I've tried it and it seems to work - to do this:

Locate your Next-Gen project's ID:

  1. Go to https://<your instance name>
  2. Locate your Project - use your browser search (Ctrl+F or Cmnd+F) to search via Key or Name
  3. Copy your Project's ID

Next locate your status' ID:

  1. Go to https://<your instance name>
  2. Search for your Project ID - next to it there will be the statuses with their status IDs. These are usually five digits in length and should start with 10, 100 or similar (depending how many custom statuses are on your instance).
  3. Copy the relevant Status ID

You can now search using the ID - eg. "Status was 101323".


Thanks ! I tought it was not possible to use the status ID with WAS as written In the JQL Fields Reference. Should it be changed ? or is it specific to Next-gen projects issues ?

I'm not sure - but I did try some non-Next-Gen statuses from our instance and all of them appeared to work (including one of the "default" statuses) - so it appears to work across all :)


This works for me in next-gen Jira, thank you!

With further investigation, it seems to happen when you have a status with the same name as one of the basic statuses (without scope)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,120 views 8 28
Join discussion

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