For instance, is there a way to report all of the tickets in the DB in
an elegant manner like:
Total:
New: X
Open: Z
Etc etc
Between a time period?
Or Tickets by user:
XXX@ZZZ: ZZZ
YYYY@YYY: ZZZ
Anton Krall
Intruder Consulting
email: akrall@intruder.com.mx
Celular: 044-555-105-5160
ICQ#: 4979450-----Original Message-----
From: Bruce Campbell [mailto:bruce_campbell@ripe.net]
Sent: Sábado, 06 de Julio de 2002 02:40 a.m.
To: Anton Krall
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] how to delete user
On Fri, 5 Jul 2002, Anton Krall wrote:
I also have another question… Dead tickets… Im trying to do a
search on tickets… And I cann see all… Open, new, resolved but no
dead :)) how can I see what tickets are marked dead???
Whenever I do a search and I input status = dead nothing comes up when
in fact I know I have dead tickets…
( please remember to trim your replies to only the relevant bits in
future )
The thinking behind it is that you don’t want to be retrieving old
‘dead’ issues through the normal UI. If you do want to be able to do
it, the code which makes it happen is in lib/RT/Tickets.pm:
#Make sure we _never_ show dead tickets
#TODO we should be doing this in the where clause.
#but you can't do multiple clauses on the same field just
yet 
if ($Ticket->Status eq 'dead') {
return($self->Next());
}
Most times, when people are interested in ‘dead’ tickets, they’re also
on the way to risking damage to their kneecaps by removing records from
the database[1], and have written/are using their own script to do so.
Jesse - the above gotcha seems to date from a workaround on an older
version of SearchBuilder; I don’t think its still relevant, and could be
fixed in the newer releases more elegantly 
Regards,
Bruce Campbell
RIPE
Systems/Network Engineer
NCC
www.ripe.net - PGP562C8B1B
Operations
[1] The code explains this reference 
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002