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

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • 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

Next Gen - How to search tickets that were in progress during a certain period? Edited

Hey I'd like to search for issues that were in progress during the last months (even a few days)

 

I can't make this JQL return anything on my Next Gen project, I don't understand why ...

status was 'In Progress' DURING ("2019/10/01","2019/10/31")

 

Thanks for your help!

 

3 answers

1 accepted

0 votes
Answer accepted

Workaround for the issue :

Renaming my in progress column back and forth from « En cours » to « PN: En cours » and then « En cours » again

I’m now able to search with status was « En cours » which is exactly what I wanted.

0 votes
Jack Community Leader Nov 14, 2019

how about this...

status was "In Progress" AFTER "2019/11/01"

if you want to bound it to exclude items that were not moved out of IP by the end of the month....

status was "In Progress" AFTER "2019/11/01" and status was not "in progress" after "2019/11/30"

Thanks, but it does not change anything. My query is still returning nothing (see my answer to @John Funk

Jack Community Leader Nov 15, 2019

I was just playing with this and while my testing isn’t exhaustive as I’m on my smartphone which is challenging for JQL play, it appears that indeed the “was in” doesn’t work in NG. You may wish to report to Atlassian Support. Maybe this is a known limitation. If you do, please report back here. 

Like Christian Blavier likes this

Thank you Jack, I will do!

0 votes
John Funk Community Leader Nov 14, 2019

Hi Christian - Welcome to the Atlassian Community!

I executed your query exactly as it was (minus the single quote marks at each end) and it worked perfectly.

What kind of error are you getting?

John Funk Community Leader Nov 14, 2019

And is there a particular issue that you think should be showing up that isn't?

No error, the query is just returning nothing.

If I run it on other (non next-gen JIRA projects), the query is also working

I'm wondering if my current next-gen project is lacking status history or something like that?

For sure yes the query should return issues.

Actually, even the query

project = PN AND status was "In Progress" 

without any date is not returning anything 

John Funk Community Leader Nov 14, 2019

Wow - are you sure you have Browse Project permissions on that project? Can you take the status part off and see anything at all on the project?

I'm admin on the project, see screenshots below

 

screen1.jpgscreen2.jpg

John Funk Community Leader Nov 14, 2019

Thanks for sharing those. Can you go to the board and see if there are actually any cards for the In Progress status? Maybe even create a test card and move it to that Status to see if it will show up in the JQL. 

John Funk Community Leader Nov 14, 2019

And maybe a screenshot of your Workflow. 

Here is my board with 4 tickets in the "En cours" status.

Is there as such thing as a workflow editor in Next-Gen projects?

 

screen3.jpg

Hi @John Funk

Any idea how to solve my problem?

Do you think I should create a bug report?

John Funk Community Leader Dec 02, 2019

Sorry - yes, you should contact Atlassian support. 

John Funk Community Leader Jan 03, 2020

Hey @Christian Blavier - did you ever get this solved?

Yes I have, thanks to Atlassian support.

It is a known issue but I could work around it by renaming my in progress column back and forth from « En cours » to « PN: En cours » and then « En cours » again

I’m now able to search with status was « En cours » which is exactly what I wanted.

John Funk Community Leader Jan 06, 2020

Great! Glad you got it to work.  :-)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,623 views 22 33
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