Setting up a queue to search for multiple keywords in description AND created

Question

Hi,

I'm looking to create a queue on Service desk to look for bug tickets created in the past 2 weeks from today's date, and that also could contain 1 of 6 different email addresses in it:

created <= "-14d" AND description ~ "email" OR description ~ "email" OR description ~ "email" OR description ~ "email"

This seems to work for the text in the description, but not for created. Instead, it's showing me tickets from the past year.

Where did I go wrong?

Steven F Behnke · Answer

I always get those date operators wrong.

Raphael_m09ics · Answer

Oh, just got it. It was supposed to be >= not <=! Thanks!

Raphael_m09ics · Answer

Steven--thanks. Added the parenthesis, however it's still returning issues from over a year ago.

created <= "-14d" AND (description ~ "email" OR description ~ "email" OR description ~ "email" OR description ~ "email" OR description ~ "email" OR description ~ "email")

Thoughts?