[rt-users] searching resolved ticket dependancies

[Alex Young]

Hi,

          I'm trying to do a search of tickets that are new and open,
but only if they don't depend on any other tickets or the tickets they
depend on has been resolved.

 

I had this so far:

( Status = 'new' OR Status = 'open' ) AND FinalPriority > 0 AND Due < '2
days' AND DependsOn = 'NULL'

 

This wont quite work, as it wont display tickets when their parent
dependant ticket has been resolved.

 

I want do this so I can use rt-crontool to escalate tickets each
evening, while leaving dependant tickets untouched until their parent
dependant has been resolved.

 

Any ideas? Can it be done?

 

Thanks.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081009/16918767/attachment.htm>