[rt-users] TicketSQL for dependencies

[Ruslan Zakirov]

On Wed, Sep 3, 2008 at 1:26 AM, Aaron D. Ball <adb at broad.mit.edu> wrote:
> 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?
Nope :(

>
> --
> 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.