I have a issue with queries using resolved that has just started the within the last 2 weeks - so when using the option below: resolved >= startOfDay(-6d) ORDER BY resolved We are getting issues that have not been resolved but within the dates that are

[William Causey]

I have a issue with queries using resolved that has just started the within the last 2 weeks - so when using the option below:

resolved >= startOfDay(-6d) ORDER BY resolved

We are getting issues that have not been resolved but within the dates that are included but we want only the resolved issues.

[William Causey]

My real question is: with resolved >=startofDay(-6d) ORDER BY resolved

Will this give only the issues within last 6 days or about a week that where resolved or will it give all the issues and order them by their resolve status? What should I expect from the query that is above? That is really all I want to know

[Jaime S]

Hi, William.

I'm not absolutely sure I understood what you want. Do you want to remove the unresolved issues from the query? In this case, this should work:

resolved >= startOfDay(-6d) and resolution is not null ORDER BY resolved

Kind regards.