Searching resolved ticket dependancies

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.

Alex,

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

I'm curious, how did a parent ticket get resolved if the "DependsOn" is 

still new or open? I thought the whole purpose of a "DependsOn"
relationship was to keep the parent from getting resolved until the
dependencies are also resolved, first. At least, that is what my testing
has shown.

Kenn
LBNLOn 10/8/2008 4:55 PM, Alex Young wrote:

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.



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com