Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Setting up a queue to search for multiple keywords in description AND created <= "-14d"

Raphael June 27, 2018

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?

1 answer

0 votes
Steven F Behnke
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2018
created <= "-14d" AND (description ~ "email" OR description ~ "email" OR description ~ "email" OR description ~ "email")

Notice my use of parenthesis. 

Raphael June 27, 2018

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?

Raphael June 27, 2018

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

Steven F Behnke
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 27, 2018

always get those date operators wrong. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events