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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
