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.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.