How do I do cross table queries for searches

I’m trying to have a query return the fields Address1 and WorkPhone from
the Users table, but I’m not having much luck.

So far, I have added these lines to the ColumnMap file located in my
/opt/rt3/local/html/Elements/RT__Ticket directory:

 OwnerOffice => {
     title     => 'Location',
     value     => sub  { return $_[0]->OwnerObj->Address1 }
 },
 OwnerPhone => {
     title     => 'Phone',
     value     => sub  { return $_[0]->OwnerObj->WorkPhone }
 },

However, they do not show up in the “Add Columns:” field of the Query
Builder.

Can anyone clue me in on what I’m doing wrong?

Thanks in advance!

Kevin Colagio: Systems Analyst, Reef Geek, and Perpetual Student
Computing and Information Technology, SUNY at Geneseo, South 124
colagio@geneseo.edu    (585) 245-5577     http://www.geneseo.edu

Experience is a harsh teacher, the tests are first, the lessons follow.

Add these items to the @fields array in
/Search/Elements/BuildFormatString. That should make them show up in the
’Add Columns’ multiple select box.

Adam-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kevin
Colagio
Sent: Friday, January 13, 2006 1:45 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] How do I do cross table queries for searches

I’m trying to have a query return the fields Address1 and WorkPhone from
the Users table, but I’m not having much luck.

So far, I have added these lines to the ColumnMap file located in my
/opt/rt3/local/html/Elements/RT__Ticket directory:

 OwnerOffice => {
     title     => 'Location',
     value     => sub  { return $_[0]->OwnerObj->Address1 }
 },
 OwnerPhone => {
     title     => 'Phone',
     value     => sub  { return $_[0]->OwnerObj->WorkPhone }
 },

However, they do not show up in the “Add Columns:” field of the Query
Builder.

Can anyone clue me in on what I’m doing wrong?

Thanks in advance!

Kevin Colagio: Systems Analyst, Reef Geek, and Perpetual Student
Computing and Information Technology, SUNY at Geneseo, South 124
colagio@geneseo.edu    (585) 245-5577     http://www.geneseo.edu

Experience is a harsh teacher, the tests are first, the lessons follow.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html