I simply want to pull in tickets that have been created this month and that Work Request Type is NOT BAU Manual Recurring. However, I DO get BAU Manual Recurring the moment I add in the "work request type[dropdown]" IS EMPTY part.
created >= startOfMonth() AND project = AML AND ("work request type[dropdown]" != "BAU Manual Recurring" OR "work request type[dropdown]" IS EMPTY) ORDER BY created ASC
I figured it out myself. while I don't get why the AND ("work request type[dropdown]" != "BAU Manual Recurring" OR "work request type[dropdown]" IS EMPTY) statement doesn't work, the following worked for me. If anyone has an explanation, please do educate me.
The code that is working:
created >= startOfMonth()
AND project = AML
AND ("work request type[dropdown]" IN (New, "Modification / Enhancement", "Test_&_Learn") OR "work request type[dropdown]" IS EMPTY)
ORDER BY created ASC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.