JQL How get issue where status was in "Waiting" ?

[Alex]

Hello everyone! I'm trying to find tasks with JQL that was in the waiting status (today, yesterday, etc.)

I would appreciate any help. Thank you.

[Nicolas Tagle · Accepted solution]

Hello Oliver,

The JQL you are looking for is something like this:

status changed FROM "Waiting for customer" DURING (-1d, now())

Where the key is "change FROM"  and DURING(-1d, now()) to determine the time windows. There is a lot of modifications to this JQL to match what you need but I think it covers the basics, hope it helps you out.

Best regards,

Nico.

[Alex]

@Nicolas Tagle Hi!Thank you for help! It's worked!Have nice day!

[Nicolas Tagle]

Awesome!, you too, take care!

[Alex · Accepted solution]

First day:

project = "your project" AND status changed TO "Waiting" DURING (startOfDay(), now() )

Second day: 

"your project" AND status changed TO "Waiting" DURING (-1d, -1d)

[Karolina Wons_SaaSJet]

Hello @Alex 

You can use a JQL proposed by @Nicolas Tagle if it meets your needs

But if I understand you correctly, you would like to display time in status data for tasks with JQL, wouldn't you?

If so, I recommend you try some apps from the Atlassian Marketplace

Hope you find the one that fits your needs the best

[Alex]

@Karolina Wons_SaaSJet  Hi! Thank you!