Man, I must be really obtuse, because I can’t get this thing to work. 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:
my $tickets = new RT::Tickets($RT::SystemUser);
$tickets->LimitTransactionDate( VALUE => $startobj->ISO, OPERATOR =>
‘>=’);
$tickets->LimitTransactionDate( VALUE => $endobj->ISO, OPERATOR =>
’<=’);
$tickets->LimitStatus( VALUE => ‘open’, OPERATOR => ‘=’);
while (my $ticket = $tickets->Next()) {
my $transes = $ticket->Transactions();
$transes->Limit( FIELD => ‘Created’,
VALUE => $startobj->ISO,
OPERATOR => ‘>=’,
ENTRYAGGREGATOR=> ‘AND’ );
$transes->Limit( FIELD => 'Created',
VALUE => $endobj->ISO,
OPERATOR => '<=',
ENTRYAGGREGATOR => 'AND');
$transes->_DoSearch();
next unless ($transes->Count > 0);
But I’m damned if I can figure it out. Looking at some of the other places
where the order is set has only confused me more.
Help!
Thanks
Tom
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
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@boston.com wrote:
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@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
Yup, that did it. Perhaps I should just ask you directly next time?
The answers (and praise, hint hint go into the archives, though…
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.
In the past, I’ve spent some time poking about in $RT/lib;
RT::Interface::{Web,Email,CLI} define helper functions and other Useful
Things relevant to specific interfaces to RT. In this case, I looked in
WebRT/html/Search/Listing.html, saw that the arg processing was handled
by ProcessSearchQuery, and then ran:
find $RT/lib -name *.pm -print | xargs grep ProcessSearchQuery
(find | xargs grep is your friend!)
Warning: We’re running an old (2.0.0 pre15!) version of RT, so what I’m
telling you might be out of date.
(darren)
Everybody wants to go to heaven, but nobody wants to die.
– Peter Tosh
I looked in Listing.html, but I didn’t know where to go from there. And I
am no stranger to find and xargs grep, trust me… I just couldn’t
figure out what to look for from there. I’m a Sun/Linux admin by trade,
hacker by necessity…
Tom–On Wednesday, February 19, 2003 3:15 PM -0500 darren chamberlain darren@boston.com wrote:
Yup, that did it. Perhaps I should just ask you directly next time?
The answers (and praise, hint hint go into the archives, though…
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.
In the past, I’ve spent some time poking about in $RT/lib;
RT::Interface::{Web,Email,CLI} define helper functions and other Useful
Things relevant to specific interfaces to RT. In this case, I looked in
WebRT/html/Search/Listing.html, saw that the arg processing was handled
by ProcessSearchQuery, and then ran:
find $RT/lib -name *.pm -print | xargs grep ProcessSearchQuery
(find | xargs grep is your friend!)
Warning: We’re running an old (2.0.0 pre15!) version of RT, so what I’m
telling you might be out of date.
(darren)
–
Everybody wants to go to heaven, but nobody wants to die.
– Peter Tosh
rt-users mailing list
rt-users@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