Description 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 : * Create a new next-gen product. * Add issues * Make one of the issues In Progress * Query your project issues with query like above with todays date in during * You will receive an empty response * Go back in your next-gen project * rename the In Progress column to 'In Prog' * Query again changing the status name * It works.

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: * Go to https:// .atlassian.net/rest/api/3/project * Locate your Project - use your browser search (Ctrl+F or Cmnd+F) to search via Key or Name * Copy your Project's ID Next locate your status' ID: * Go to https:// .atlassian.net/rest/api/3/status * 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). * Copy the relevant Status ID You can now search using the ID - eg. "Status was 101323". Ste

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; } } }

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

Antoine Emond

Description
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 :

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

Accepted answers

Ste Wright

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:

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

Next locate your status' ID:

Go to https://<your instance name>.atlassian.net/rest/api/3/status
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).
Copy the relevant Status ID

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

Ste

All comments

Antoine Emond

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

Ste Wright

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:

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

Next locate your status' ID:

Go to https://<your instance name>.atlassian.net/rest/api/3/status
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).
Copy the relevant Status ID

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

Ste

Antoine Emond

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 ?

Ste Wright

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

Ste

Dave Rench McCauley_f1k8vk

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql

next-gen

status