Can't search on status=deleted

RT Users
1

Is this by design in 3.6.1rc2?

David Smithson
ActivSupport, Inc.
Your Flexible IT Partner
Microsoft Gold Partner – Small Business Specialist

Director of Technical Services
Direct: (415) 869 2991
Technical Support Hotline: (415) 979 9285
CLICK HERE FOR ONLINE SUPPORT

2

I suppose it doesn’t matter. I’ve found and made use of RTx-Shredder,
which finds Tickets with status=‘deleted’.

David Smithson

CLICK HERE FOR ONLINE SUPPORT-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of David
Smithson
Sent: Tuesday, August 01, 2006 11:09 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] can’t search on status=deleted

Is this by design in 3.6.1rc2?

David Smithson
ActivSupport, Inc.
Your Flexible IT Partner
Microsoft Gold Partner – Small Business Specialist

Director of Technical Services
Direct: (415) 869 2991
Technical Support Hotline: (415) 979 9285
CLICK HERE FOR ONLINE SUPPORT

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

3

David Smithson wrote:

I suppose it doesn’t matter. I’ve found and made use of RTx-Shredder,
which finds Tickets with status=‘deleted’.

David Smithson

CLICK HERE FOR ONLINE SUPPORT

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of David
Smithson
Sent: Tuesday, August 01, 2006 11:09 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] can’t search on status=deleted

Is this by design in 3.6.1rc2?

David Smithson

ActivSupport, Inc.
Your Flexible IT Partner
Microsoft Gold Partner – Small Business Specialist
http://www.activsupport.com
Director of Technical Services
Direct: (415) 869 2991

Technical Support Hotline: (415) 979 9285
CLICK HERE FOR ONLINE SUPPORT

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

RT won’t do searches on deleted tickets. in order to see them you
either have to do queries directly in the database or as you’ve already
discovered, vi Shredder.

Mathew Snyder

4

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On Wed, 2 Aug 2006 at 03:32 (-0400), Mathew Snyder wrote:

RT won’t do searches on deleted tickets. in order to see them you
either have to do queries directly in the database or as you’ve already
discovered, vi Shredder.

Although, you can search on deleted tickets from a perl script, e.g.:

my $TicketList = new RT::Tickets($RT::SystemUser):
my $ticket1 = "$ARGV[0]";
my $ticket2 = "$ARGV[1]";

$TicketList->{'allow_deleted_search'} = 1;
$TicketList->LimitStatus(VALUE => "deleted");

# Search for deleted tickets within the specified ticket range:
$TicketList->LimitId(OPERATOR => '>=', VALUE => $ticket1);
$TicketList->LimitId(OPERATOR => '<=', VALUE => $ticket2);

Mike

Mike Friedman IST/System and Network Security
mikef@berkeley.edu 2484 Shattuck Avenue
1-510-642-1410 University of California at Berkeley
Socrates and Berkeley Scholars Web Hosting Services Have Been Retired | Web Platform Services http://security.berkeley.edu

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBRODYAK0bf1iNr4mCEQLJdwCfSCz9H6obVXAuHI3P2T1ptqiGmPsAnjTM
FsDQQ33wIekF9V0KlXFiMKmv
=Fwhk
-----END PGP SIGNATURE-----

5

Mike Friedman wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

RT won’t do searches on deleted tickets. in order to see them you
either have to do queries directly in the database or as you’ve
already discovered, vi Shredder.

Although, you can search on deleted tickets from a perl script, e.g.:

my $TicketList = new RT::Tickets($RT::SystemUser):
my $ticket1 = “$ARGV[0]”;
my $ticket2 = “$ARGV[1]”;

$TicketList->{‘allow_deleted_search’} = 1;
$TicketList->LimitStatus(VALUE => “deleted”);

Search for deleted tickets within the specified ticket range:

$TicketList->LimitId(OPERATOR => ‘>=’, VALUE => $ticket1);
$TicketList->LimitId(OPERATOR => ‘<=’, VALUE => $ticket2);

Mike

Mike Friedman IST/System and Network Security
mikef@berkeley.edu 2484 Shattuck Avenue
1-510-642-1410 University of California at Berkeley
Socrates and Berkeley Scholars Web Hosting Services Have Been Retired | Web Platform Services http://security.berkeley.edu

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBRODYAK0bf1iNr4mCEQLJdwCfSCz9H6obVXAuHI3P2T1ptqiGmPsAnjTM
FsDQQ33wIekF9V0KlXFiMKmv
=Fwhk
-----END PGP SIGNATURE-----

Or you could install RTx::Shredder which provides the option within RT.
Of course, it is a limited function considering the idea is to
ultimately remove the deleted tickets from the database. But it will
give you a list of all of them.

Mathew Snyder