[rt-users] TicketSQL for HasMember?

Ruslan Zakirov ruz at bestpractical.com
Fri Feb 29 06:30:43 EST 2008


I've fixed it in 3.7 dev branch recently.

On Fri, Feb 29, 2008 at 7:15 AM, Tom Lanyon <tom at netspot.com.au> wrote:
> 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
>
>
> _______________________________________________
>  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.



More information about the rt-users mailing list