[rt-users] TicketSQL for HasMember?

[Tom Lanyon]

On 29/02/2008, at 1:18 PM, Tom Lanyon wrote:

> Hi List,
>
> Can I add a clause to my Ticket SQL query to say "has a dependancy" ?
>
> I am searching for tickets but do not want to return ones that depend
> on another.
>
> Thanks,
> Tom

I've tried "Queue = 'General' AND HasMember IS NOT NULL" as indicated  
on the wiki (http://wiki.bestpractical.com/view/TicketSQL). However  
this returned no results.

Nevermind, as I wrote this I figured it out... "AND DependsOn IS NOT  
NULL".

Thanks anyway :)
Tom