[rt-users] How do I do cross table queries for searches

[Myers, Adam]

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 at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin
Colagio
Sent: Friday, January 13, 2006 1:45 PM
To: rt-users at 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 at 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