[rt-users] Sorting records in report using Weekly.html
Tom Lichti
tom at redpepperracing.com
Wed Feb 19 15:06:41 EST 2003
Yup, that did it. Perhaps I should just ask you directly next time? :)
What is the RT::Interface that you mentioned below? I have been trying to
find a source of info on how to do what I'm doing but haven't found much.
Thanks again
Tom
--On Wednesday, February 19, 2003 3:02 PM -0500 darren chamberlain
<darren at boston.com> wrote:
> * Tom Lichti <tom at redpepperracing.com> [2003-02-19 14:53]:
>> How do I sort by Ticket ID in this report? I tried the
>> TicketsSortOrder method, Orderby method, and again, I can't seem to
>> find the right combination. I assume it should go somewhere in here:
>
> Looking through RT::Interface::Web::ProcessSearchQuery seems to
> indicate:
>
>> my $tickets = new RT::Tickets($RT::SystemUser);
>>
>> $tickets->LimitTransactionDate( VALUE => $startobj->ISO, OPERATOR =>
>> '>=');
>> $tickets->LimitTransactionDate( VALUE => $endobj->ISO, OPERATOR =>
>> '<=');
>> $tickets->LimitStatus( VALUE => 'open', OPERATOR => '=');
>
> $tickets->OrderBy(FIELD => 'Created',
> ORDER => 'DESC');
>
> Substitute variable values for 'Created' and 'DESC', of course.
>
> (darren)
>
> --
> All truth passes through three stages: first, it is ridiculed;
> next it is violently attacked; finally, it is held to be self-evident.
> -- Schopenhauer
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>
>
More information about the rt-users
mailing list