[rt-users] TicketSQL for dependencies

[Aaron D. Ball]

RT folks,

Is there a reasonable way to search for tickets that have no 
dependencies?  The TicketSQL page on the wiki suggests that "DependsOn 
is NULL" should work, but I get this error from the RT 3.6.6 "Edit 
Query" form:

  Error near ->NULL<- expecting a VALUE in 'DependsOn is NULL'
  I'm lost

This is just a first step toward understanding how to search ticket 
relationships.  Ideally I would like to end up with a set of saved 
searches that will make RT more useful for project management:  I'd like 
to have searches for "next actions" (tickets with no new/open 
dependencies) and top-level projects (tickets with dependencies and that 
nothing depends on).

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