[rt-users] TicketSQL for dependencies

[Aaron D. Ball]

Ruslan Zakirov wrote:
> quote NULL with single or double quote char

Thanks!  Oddly enough, searching on

   DependsOn is 'NULL'

seems to return only tickets that *do* depend on another ticket.  I get 
the same result with

   DependsOn is not 'NULL'

but it looks like

   DependsOn = 'NULL'

and

   DependsOn != 'NULL'

do what I want in that respect.  I can't say I have a terribly good 
sense of the syntax of TicketSQL at this point, though.

Any suggestions for how to find tickets whose dependencies, if any, are 
all closed?  Is there a DependsOnStatus or something?

-- 
Aaron D. Ball <adb at broad.mit.edu>
Senior Systems Analyst
Broad Institute of MIT and Harvard