RT’s search UI allows some incredibly complex search queries, but we
have no idea how much you guys are using it in the field.
What are the searches you’re performing every day? What’s the most
complex thing you’ve done with the query builder?
Just build your query, hit “advanced” and copy and paste the query
into a reply to this message. Be sure to tell us what you were
searching for in plain English, too.
Jesse
PGP.sig (186 Bytes)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Jesse,
our most complex query is related to a custom report tool, those
purpose is to search for all tickets within a time period on a given
queue. The query looks like this:
‘Queue = 'General' AND ((Status = “open” AND Started >= “2007-04-01”
AND Started <= “2007-05-31”) OR (Status = “new” AND Created >=
“2007-04-01” AND Created <= “2007-05-31”) OR (Status = “stalled” AND
LastUpdated >= “2007-04-01” AND LastUpdated <= “2007-05-31”) OR (Status
= “resolved” AND Resolved >= “2007-04-01” AND Resolved <= “2007-05-31”)
OR (Status = “rejected” AND LastUpdated >= “2007-04-01” AND LastUpdated
<= “2007-05-31”))’
Jesse Vincent wrote:
RT’s search UI allows some incredibly complex search queries, but we
have no idea how much you guys are using it in the field.What are the searches you’re performing every day? What’s the most
complex thing you’ve done with the query builder?Just build your query, hit “advanced” and copy and paste the query into
a reply to this message. Be sure to tell us what you were searching for
in plain English, too.Jesse
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGS2rvjGXbUSvc3AsRAtH0AJ99wOCXwviE/wiBxxi10+OF8eFjbQCeNGpg
f2E/DPc0/jDmBP2QEmBWyp0=
=LDAS
-----END PGP SIGNATURE-----