[rt-users] Search

[Bryon Baker]

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
bbaker at copesan.com<mailto:cstephan at copesan.com>
www.copesan.com<http://www.copesan.com/>
"Servicing North America with Local Care"

From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov
Sent: Thursday, September 05, 2013 1:52 PM
To: Bryon Baker
Cc: RT Users (rt-users at lists.bestpractical.com)
Subject: Re: [rt-users] Search



On Thu, Sep 5, 2013 at 10:10 PM, Bryon Baker <bbaker at copesan.com<mailto:bbaker at 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
bbaker at copesan.com<mailto:cstephan at copesan.com>
www.copesan.com<http://www.copesan.com/>
"Servicing North America with Local Care"




--
Best regards, Ruslan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130905/7ba4601b/attachment.htm>