[rt-users] TicketSQL for dependencies

[Ruslan Zakirov]

quote NULL with single or double quote char

On Wed, Sep 3, 2008 at 12:09 AM, Aaron D. Ball <adb at broad.mit.edu> wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.