[rt-users] how to delete user

[Anton Krall]

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 at ZZZ: ZZZ
YYYY at YYY:  ZZZ


__________________________________________________________________
Anton Krall
Intruder Consulting
 
email: akrall at intruder.com.mx
Celular: 044-555-105-5160
ICQ#: 4979450

 


-----Original Message-----
From: Bruce Campbell [mailto:bruce_campbell at ripe.net] 
Sent: Sábado, 06 de Julio de 2002 02:40 a.m.
To: Anton Krall
Cc: rt-users at 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