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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.