[rt-users] is there a way to list dead TIckets?

[Stephane Bortzmeyer]

On Thu, May 02, 2002 at 08:51:16PM +0000,
 naoy at levillage.org <naoy at levillage.org> wrote 
 a message of 18 lines which said:

> i 'pretty new whith RT and i can't list dead tickets, i can list new,
> open , stailed, an resovle but when I chose dead: nothing, in the database

Funny, same problem for me. RT 2.0.11 (not updated to 2.0.13 yet,
bad).

rt2=# SELECT count(*) FROM tickets WHERE status = 'dead';
 count 
-------
     2

But RT's Search interface shows nothing (stalled tickets are displayed
fine).