[rt-users] RE: Help with query and display

[Mahoney, Tim]

This is probably the line of code you're looking for.

%$Ticket->OwnerObj->Name%

This is what pulls the owner's name in the MyRequests element.  You might be
able to rewrite this element to only show the Service tickets.

Thanks
Tim Mahoney
Win Svr 2003 / RT 3.0.12 / Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18

-----Original Message-----
From: Dave Kettmann [mailto:dkettmann at netlogic.net] 
Sent: Thursday, January 12, 2006 9:37 AM
To: Dave Kettmann; rt-users at lists.bestpractical.com
Subject: [rt-users] RE: Help with query and display

Anyone? .. Bueller? .. This should be a simple fix I would think?

Dave

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Dave Kettmann
Sent: Wednesday, January 11, 2006 11:19 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Help with query and display

Hi all,

I'm trying to get a custom query to display on the main page of RT. Here is
the contents of the file ...

--<code>--

<&|/Elements/TitleBox,
        title => loc('Pending Service Calls'),
        title_href => "Search/Results.html".$QueryString &> <&
/Elements/TicketList,
        Format => "'<a
href=\"$RT::WebPath/Ticket/Display.html?id=__id__\">__id__</a>/TITLE:#',
'<a
href=\"$RT::WebPath/Ticket/Display.html?id=__id__\">__Subject__</a>/TITL
E:Subject',  __ExtendedStatus__, __DueRelative__, __Owner__",

        Query => $Query,
        OrderBy => 'id',
        Order => 'ASC',
        ShowNavigation => 0
        &>
</&>
<%init>

my $Query = " Status = 'service' ";

my $QueryString = '?' . $m->comp('/Elements/QueryString',
            Query => $Query,
            Order => 'ASC',
            OrderBy => 'id') if ($Query);

</%init>

--</code>--

All of the data displays except the Owner. I think I am just not referencing
it by the right name. Any help is greatly appreciated...

Also, is there anywhere that I can find all of the possibilities for fields
in a custom search?

Thanks,

Dave Kettmann
NetLogic
314-266-4000



_______________________________________________
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



_______________________________________________
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