Hello!
I am working on creating a code to run a report based off summary and a date range. When I have the part with the date range only, it works fine and the section with the summary also works by itself. However, when I add the entire string however, it seems to cancel out the date range part of the code. This is the string I am using. I don't understand why adding more removed the date function, when I can stack other filters just fine.
createdDate >= 2021-11-25 AND createdDate <= 2022-10-01 AND summary ~ "disable employee" OR summary ~ "New Employee" OR summary ~ "Transfer Employee" AND project = ISR AND status in (Closed, Done, Resolved)
I am hoping there is just a part I am missing in this.
Hi @Chelsea Ebaugh ,
I think what you wanted to do is to separate ORs in the brackets, like this:
createdDate >= 2021-11-25 AND createdDate <= 2022-10-01 AND (summary ~ "disable employee" OR summary ~ "New Employee" OR summary ~ "Transfer Employee") AND project = ISR AND status in (Closed, Done, Resolved)
If you do not use them, you search for these issues:
So the date is used only in the first case.
The way I suggested you search for issues how you probably need to.
Thank you, Adam.
This worked to fix the issue. Have a great day!
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.