I'm writing a Filter to pull specific Assignment Groups, created today in Open status

Question

I'm writing a Filter to pull specific Assignment Groups, created today in Open status' within the ITSM Project.     But the below query still pulls in tickets created prior to today and also pulls in SERV tickets.   What am I doing wrong?

Project = ITSM and "Assignment Group" = "Service Desk" AND created > startOfDay()  AND status not in (Canceled, Cancelled, Closed, "Closed - Complete", "Closed - Incomplete", "Closed - Skipped", Declined, Done, Resolved) AND project = "IT Service Management" ORDER BY created DESC

Frank Robb · Answer

Thanks Walter, this is very helpful.      Now, if I add an additional Assignment Group (below), it pulls ITSM tickets prior to today.

Project = ITSM and "Assignment Group" = "Service Desk" OR "Assignment Group" = "Procurement"
AND created > startOfDay() AND resolution = unresolved
ORDER BY created DESC

Walter Buggenhout · Answer

Hi @Frank Robb and welcome to the community!

Apart from the fact that your JQL statement could be simpler, I don't see any major errors there. Just try to simplify to something like this:

Project = ITSM and "Assignment Group" = "Service Desk"
AND created > startOfDay()  AND resolution = unresolved
ORDER BY created DESC

The above assumes that you apply the best practice to set a resolution when you set an issue to a done status. If that is not the case, you can also use the following instead of resolution = unresolved:

statusCategory != Done

Hope this helps!