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.