TicketSQL for HasMember?

RT Users
1

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

2

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 :slight_smile:
Tom

3

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,
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 :slight_smile:
Tom

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.