Bummer I really needs this in the UI. Let’s try asking the question a different way.
I have Custom fields on a ticket Client, Location, City, St. I would like a search that counts the tickets and groups by the above custom fields in one report. I can do them by one custom field at a time but I want them all in one report. Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com<mailto:cstep...@copesan.com> www.copesan.com<http://www.copesan.com/> "Servicing North America with Local Care" From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov Sent: Thursday, September 05, 2013 1:52 PM To: Bryon Baker Cc: RT Users (rt-users@lists.bestpractical.com) Subject: Re: [rt-users] Search On Thu, Sep 5, 2013 at 10:10 PM, Bryon Baker <bba...@copesan.com<mailto:bba...@copesan.com>> wrote: Hello All Is it possible to build a custom search that queries a foreign table? A table that RT does not know about natively but exists in the same Mysql instance. If so hopefully I can be led in the direction as to how. It's possible with API, but not in the UI. See how RT calls `my $alias = $tickets->Join()` and then ->Limit(...) using that alias. Thanks in advance Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 bba...@copesan.com<mailto:cstep...@copesan.com> www.copesan.com<http://www.copesan.com/> "Servicing North America with Local Care" -- Best regards, Ruslan.