[rt-users] Your most complex ticket searches?

[Subredu Manuel]

-----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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover 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-----