Tickets which were registered in JIRA for the previous week AND tickets which were registered earlie

kotha Eswar rao

Need the JQUERY for the below requirement

Tickets which were registered in JIRA for the previous week AND tickets which were registered earlier but were still open.

 

Could you please assist for the above requirement and share the exact J QUERY

 

Regards

Eshwar

Dirk Ronsmans

Hi @kotha Eswar rao ,

I believe you mean a JQL instead of a JQUERY.

For tickets registered in the previous week you could use:

created <= startOfWeek() AND created >= startOfWeek(-1)

that should give you a time frame between start of this week and start of the previous week meaning last week.

then for registered earlier but still open

created <= startOfWeek(-1) AND resolution = Unresolved

meaning everything created before the start of last week which is not yet resolved. (has no resolution

If you want to combine them you can do

created <= startOfWeek() AND created >= startOfWeek(-1) OR created <= startOfWeek(-1) AND resolution = Unresolved

which should combine both subsets in to one result.