On Thu, Sep 5, 2013 at 10:10 PM, Bryon Baker <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 <cstep...@copesan.com>**** > > www.copesan.com**** > > *"Servicing North America with Local Care"***** > > ** ** > -- Best regards, Ruslan.