I am using the query builder in RT and I want to run the following query
Owner=‘3621’ or
Owner=‘82’ or
Owner=‘86’ or
Owner=‘84’ or
Owner=‘78’ or
Owner=‘90’ or
Owner=‘4003’ or
Owner=‘4139’ or
Owner=‘80’
and Status=‘open’
this is the SQL statement that I want to run but in the builder I can either
do OR and AND not both.
How do I do this?
My objective to get a list of all the open tickets for my team.
Please let me know if you have any questions.
Thanks,
Rob Wilson
Project Manager
Plattformad
500 N. Rogers Rd.
Olathe, KS 66062
Phone: 913-254-6779
Fax: 913-764-3098