Advanced query

RT Users
1

Greetings,

Is it possible to perform an SQL join to another table when creating an
(advanced) query?

I am not looking at adding additional “search criteria”, but rather
display more information.

I would like to get the “Real Name” of a requestor in the result set of
my query.

Any thoughts?

Thanks,

Matt Zagrabelny - mzagrabe@d.umn.edu - (218) 726 8844
University of Minnesota Duluth
Information Technology Systems & Services
PGP key 1024D/84E22DA2 2005-11-07
Fingerprint: 78F9 18B3 EF58 56F5 FC85 C5CA 53E7 887F 84E2 2DA2

He is not a fool who gives up what he cannot keep to gain what he cannot
lose.
-Jim Elliot

signature.asc (197 Bytes)

2

Matt,

You didn’t mention your RT version but the answer is probably no. However
you can easily add that with a callback.

Keep in mind that a ticket can have more than one requestor.

-ToddOn Mon, Jan 5, 2009 at 5:17 PM, Matt Zagrabelny mzagrabe@d.umn.edu wrote:

Greetings,

Is it possible to perform an SQL join to another table when creating an
(advanced) query?

I am not looking at adding additional “search criteria”, but rather
display more information.

I would like to get the “Real Name” of a requestor in the result set of
my query.

Any thoughts?

Thanks,

–
Matt Zagrabelny - mzagrabe@d.umn.edu - (218) 726 8844
University of Minnesota Duluth
Information Technology Systems & Services
PGP key 1024D/84E22DA2 2005-11-07
Fingerprint: 78F9 18B3 EF58 56F5 FC85 C5CA 53E7 887F 84E2 2DA2

He is not a fool who gives up what he cannot keep to gain what he cannot
lose.
-Jim Elliot

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

3

Greetings,

Is it possible to perform an SQL join to another table when creating an
(advanced) query?

I am not looking at adding additional “search criteria”, but rather
display more information.

I would like to get the “Real Name” of a requestor in the result set of
my query.

The code you’d want to change is in
share/html/Elements/RT__Ticket/ColumnMap

You’re looking at the ‘Requestors’ entry.