[rt-users] advanced query

[Jesse Vincent]

On Mon  5.Jan'09 at 16:17:07 -0600, Matt Zagrabelny 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.

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

You're looking at the 'Requestors' entry.

> 
> Any thoughts?
> 
> Thanks,
> 
> -- 
> Matt Zagrabelny - mzagrabe at 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



> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090106/0b782ad1/attachment.sig>