Issues cancelled over last 7 days from yesterday?

[NAW]

Hi, i wanted to know all the issues that are cancelled over last 7 days from yesterday..I am having trouble creating a jql query, kindly let me know..I don't want to hard code the date.

[Jared Dohrman [Design Industries] · Accepted solution]

Hi NAW,

Is Cancelled a status or resolution? You could use something like

status = closed AND status changed to closed after startOfDay(-7) AND status changed to closed before endOfDay(-1)

(REPLACE: status with resolution and/or closed with cancelled)

Thanks,

Jared.

[NAW]

Thank you Jared!, it worked, it was a status