Re: [rt-users] advanced query

2009-01-06 Thread 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 t

Re: [rt-users] advanced query

2009-01-05 Thread Todd Chapman
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. -Todd On Mon, Jan 5, 2009 at 5:17 PM, Matt Zagrabelny wrote: > Greetings, > > Is it possible to perform an SQL

[rt-users] advanced query

2009-01-05 Thread Matt Zagrabelny
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? Tha