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
Tom Lanyon
Systems Administrator
NetSpot Pty Ltd
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
Tom Lanyon
Systems Administrator
NetSpot Pty Ltd
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 (TicketSQL - Request Tracker Wiki). However
this returned no results.
Nevermind, as I wrote this I figured it out… “AND DependsOn IS NOT
NULL”.
Thanks anyway
Tom
I’ve fixed it in 3.7 dev branch recently.On Fri, Feb 29, 2008 at 7:15 AM, Tom Lanyon tom@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,
TomI’ve tried “Queue = ‘General’ AND HasMember IS NOT NULL” as indicated
on the wiki (TicketSQL - Request Tracker Wiki). However
this returned no results.Nevermind, as I wrote this I figured it out… “AND DependsOn IS NOT
NULL”.Thanks anyway
Tom
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Best regards, Ruslan.