Re: [rt-users] TicketSQL for HasMember?

2008-02-29 Thread Ruslan Zakirov 
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

Re: [rt-users] TicketSQL for HasMember?

2008-02-29 Thread rt-users-bounces 
On Fri, Feb 29, 2008 at 02:30:43PM +0300, Ruslan Zakirov wrote:
 I've fixed it in 3.7 dev branch recently.

One thing I've wanted to be able to do but I've not seen how to do
easily is to where-clause for tickets with no unresolved dependencies.

Is this possible in TicketSQL?

TTFN
-- 
Roger.  Home| http://www.sandman.uklinux.net/
Master of Peng Shui.  (Ancient oriental art of Penguin Arranging)
Work|Independent Sys Consultant | http://www.computer-surgery.co.uk/
 New key Fpr: 72AF 0ACC 9A53 E59F B1B6  DC14 1983 A13E 5C3D 3CEB 
___
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

[rt-users] TicketSQL for HasMember?

2008-02-28 Thread Tom Lanyon 
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


___
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

Re: [rt-users] TicketSQL for HasMember?

2008-02-28 Thread Tom Lanyon 
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