Search

RT Users
1

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.

Thanks in advance

Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726 * 262-783-6261 ext. 2296
bbaker@copesan.commailto:cstephan@copesan.com
www.copesan.comhttp://www.copesan.com/
“Servicing North America with Local Care”

2

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@copesan.com cstephan@copesan.com****

www.copesan.com****

“Servicing North America with Local Care”****

Best regards, Ruslan.

3

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@copesan.commailto:cstephan@copesan.com
www.copesan.comhttp://www.copesan.com/
"Servicing North America with Local Care"From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@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

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@copesan.commailto:cstephan@copesan.com
www.copesan.comhttp://www.copesan.com/
“Servicing North America with Local Care”

Best regards, Ruslan.

4

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.

Test RT-4.2.0rc1 released today, you can group by multiple custom
fields at the same time. Please don’t upgrade your production
instance, but testing in a VM with a copy of your data would be great.

-kevin

5

Kevin is there an issue with upgrading? I am still in the implementation stage and have not gone to production.

I would be upgrading form 4.0.13.

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726 . 262-783-6261 ext. 2296
bbaker@copesan.com

“Servicing North America with Local Care”-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Thursday, September 05, 2013 5:29 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search

On Thu, Sep 05, 2013 at 07:04:50PM +0000, Bryon Baker wrote:

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.

Test RT-4.2.0rc1 released today, you can group by multiple custom fields at the same time. Please don’t upgrade your production instance, but testing in a VM with a copy of your data would be great.

-kevin

6

Kevin is there an issue with upgrading? I am still in the implementation stage and have not gone to production.

I would be upgrading form 4.0.13.

4.2.0rc1 is a release candidate. If you’re only testing, then sure,
you should be able to move your testing to target it. If you’re using
the system, I’d suggest continuing to run 4.0.13 while testing 4.2.0
release candidates in parallel.

-kevin