Hi, I want to fetch tasks which are moved to UAT(status) from Systemtest(status) in the last one week?

[Vijay]

Hi, I want to fetch tasks which are moved to UAT(status) from Systemtest(status) in the last one week?

This is the query which i have written for this... (10007) is the status id for system test.

status = UAT AND "Last Status ID" ~ "10007" AND updated >= -7d

But this query is returning more tasks which are in UAT (status) few weeks before, as the update date column is recent, as many people type some comments in the task....

Is there any other field available in JIRA?

[Deleted user · Accepted solution]

Take a look at this KB https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-WASIN

[Vijay]

Thank you very much... I have done it

status = UAT AND status was in ("System Testing") AFTER -7d

[Deleted user]

Nice cheers! Accept my answer above :)