Search filter - combine 3 "conditions"

[Oliviu Nita]

Hi,

Have strugling from a few days to create a filter that return results for that:

Resolved issues in the first hour from creation for the last week 

Have tested all the advanced JQL that i could think about without finding the good one... the results are not accurate or returnig errors.

This is - one of - the JQL exemple: 

project = DEM AND created >= -1w  AND status changed to (Resolved, Closed) BEFORE now(-1h) 

Can someone please guide me ?

Keep in mind that i don't want to install a plugin/addon for doing this, i feel that the solution is on the JQL advanced serach :)

Thank you in advance 

[Deleted user]

Hi @Oliviu Nita,

There is not really a way to get your requirement working through just an advanced JQL query. The only way to start looking at solving this (without help from Marketplace plug-ins) is to have a custom field track the value you are looking for, as part of a Workflow step. However, a lot of such requirements leverage help from third-party add-ons like ScriptRunner, if you wish to consider.

Hope this helps!

Thanks

Kalyani

[Oliviu Nita]

Thank you Kalyani, 

I will still wait some answers and i will play with customs fields before accepting your answer.

Cheers