excluding queue in RT SQL

Alex Hall <[email protected]> Thu, 9 Feb 2017 10:02:08 -0500
Newsgroups gmane.comp.bug-tracking.request-tracker.user
Message-ID <CA+Q8_JfmxX4QA=gqwcHR=XhzVLYAO_jo=1n3GUDvbkY2wcXA6Q@mail.gmail.com>
--94eb2c115298e9655405481a439b
Content-Type: text/plain; charset=UTF-8

Hi all,
Just a quick question, and one I feel like I should know. In RT's
implementation of SQL, how do I specify a queue; name or ID?

We have a cron job that runs, using SQL to search for tickets. I'm being
asked to exclude a specific queue from this search. Do I need to use "queue
<> 'queue name'" or "queue <> 7"? Thanks.

-- 
Alex Hall
Automatic Distributors, IT department
[email protected]

--94eb2c115298e9655405481a439b
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hi all,<br></div>Just a quick question, and one =
I feel like I should know. In RT&#39;s implementation of SQL, how do I spec=
ify a queue; name or ID?<br><br></div>We have a cron job that runs, using S=
QL to search for tickets. I&#39;m being asked to exclude a specific queue f=
rom this search. Do I need to use &quot;queue &lt;&gt; &#39;queue name&#39;=
&quot; or &quot;queue &lt;&gt; 7&quot;? Thanks.<br clear=3D"all"><div><div>=
<div><br>-- <br><div class=3D"gmail_signature" data-smartmail=3D"gmail_sign=
ature"><div dir=3D"ltr"><div><div>Alex Hall<br></div>Automatic Distributors=
, IT department<br></div><a href=3D"mailto:[email protected]" target=3D"_b=
lank">[email protected]</a><br></div></div>
</div></div></div></div>

--94eb2c115298e9655405481a439b--