Query to Show open and in Progress issues till yesterday

[Prabhu Chilukuri]

Hi All,

I want my query to show all issues that are in open and In progress till yesterday.

[Pramodh M · Accepted solution]

Hi @Prabhu Chilukuri 

This query is limited to Project and issues created more than 1 day ago which are in either Open status or In Progress status

project = project-key AND status in (Open, "In Progress") AND created <= -1d

Let me know if this is returning issues that you need

Thanks

[Tim Perrault · Accepted solution]

Hi @Prabhu Chilukuri,

Try this out

status changed TO (Open, "In Progress") AFTER startOfDay(-1) 

Thanks,

Tim

[Tim Perrault]

Thought about this a little more cause this could return other issues beyond just the ones in open and in progress. I added a little bit more to isolate just those issues. This will show all issues in the status of Open and in progress if they were transitioned to those status since yesterday.

status in (Open, "In Progress") AND status changed TO (Open, "In Progress") AFTER startOfDay(-1) 

[Pramodh M]

@Tim Perrault 

I guess status in (Open, "In Progress") is enough right? 

Once we have checked the issue is in Open or In Progress, why are we checking the status of the issue was changed?

[Tim Perrault]

@Pramodh M

Maybe I misinterpreted the question... I read it like can I have a query that will show me all open and in progress issues that actually got to that status since at least the day prior.

[Pramodh M]

@Tim Perrault Guess to compare the issue context we need when the issue is changed which is not given by @Prabhu Chilukuri !! 

[Pramodh M]

@Tim Perrault Your interpretation was correct but both of our approaches were different, and I appreciate yours!!

[Tim Perrault]

@Pramodh Mreally I'm just trying to get to these questions before you end up posting the correct answer haha :) I bow to the Kudos leader!

[Vic Kappel]

I have something similar to this... I want to see all issues that were open yesterday, including those that were closed today... will that above query do that, or do I need another field or two?