I need to get query for getting the list of JIRA in the same status for more than 2 weeks / 4 weeks.

Question

I need to get query for getting the list of JIRA in the same status for more than 2 weeks & 4 weeks.

For 4 weeks - I have used the query as - AND status = "In progress" AND not status changed after -4w .

For 2 weeks - I have used the query as - AND status = "In progress" AND not status changed after -2w .

But my question is I dont need the duplicate values of week 2 in week 4 ,

In short , the JIRA which are not updated after 4 weeks should only be present in 4 weeks dashboard it should not appear in 2 weeks .

Nisha Chhatwani · Answer

Hello Sir,

Thank you for your feedback .

for 4 weeks I am using - AND status = Preparation AND filter != "two weeks" AND NOT status changed after -4w

the above query is working in JIRA , but when i go to create the dashborad of it in cnfluence its not working .

Could you please help me here , why the query is not accepting in confluenece or do we have any other parameters for this ?

Jobin Kuruvilla [Adaptavist] · Answer

You mean you are still seeing the issues in the 2 weeks filter even after adding "AND filter != "two weeks""?

Can you paste your full query?

Nisha Chhatwani · Answer

Hello Sir, Thank you for your support.

for 2 weeks I have created - Filter as an "two weeks" name using query -  AND status = "In progress" AND not status changed after -2w .

for 4 weeks I am using - AND status = Preparation AND filter != "two weeks" AND NOT status changed after -4w

But still I am getting the same JIRAs in the 4 weeks dashboard.