I've fixed it in 3.7 dev branch recently. On Fri, Feb 29, 2008 at 7:15 AM, Tom Lanyon <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
-- Best regards, Ruslan. _______________________________________________ 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