RT 3.0.3pre3: Search results for deleted tickets cannot be displayed

RT Developers
1

Hi,

another bug here:

when I search for all tickets with “Status = deleted”, it says
"Found 189 tickets", but the listing is empty.

Stan

2

another bug here:

when I search for all tickets with “Status = deleted”, it says
“Found 189 tickets”, but the listing is empty.

It’s not new in 3.0.3pre3. It’s by-design and has existed for a long
time.

I think the following comments in lib/RT/Tickets_Overlay.pm explains it:

#Make sure we never show deleted tickets
#TODO we should be doing this in the where clause.
#but you can’t do multiple clauses on the same field just yet :confused:

…and you should be able to find many references in the list archives,
for example the following message from Jesse back in Sept 2001:

http://lists.fsck.com/pipermail/rt-users/2001-September/004517.html

…and in RT/FM:

http://fsck.com/rtfm/factoid.html?id=229

Hope this helps.

Spam Trap Mail Key: ASK and you shall receive

3

I think the following comments in lib/RT/Tickets_Overlay.pm explains it:
#Make sure we never show deleted tickets
#TODO we should be doing this in the where clause.
#but you can’t do multiple clauses on the same field just yet :confused:

I think this is a holdover from RT2. The RT3 Tickets infrastructure
can support multiple clauses on the same field.

The way to do it might be to see if Status goes by in
_RestrictionsToClauses – and if it doesn’t, add a Clause which is
essentially Status != deleted.

-R

4

another bug here:

when I search for all tickets with “Status = deleted”, it says
“Found 189 tickets”, but the listing is empty.

Tickets->Next automagically bypasses ‘deleted’ tickets (see code in
Tickets_Overlay.pm). To fix, redefine Next() in Tickets_Local.pm as
appropriate.

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B             Operations/Security