-----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: [EMAIL PROTECTED] > > > 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----- _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
