R: [rt-users] Quey to match cf not filled

[Gianluca Cecchi]

from the gui?
if you select a queue with a CF (at least in 3.6.5) and add it to your "current search" side, then inside the "add criteria" section you get at the bottom the CF where you can select:
 
is       (no value)
 
that when you add translates at right side to
 
AND 'CF.{Report}' IS 'NULL'
 
On the contrary you can select "isn't" to get all the tickets with the CF filled up with something.
 
HIH,
Gianluca


________________________________

	Da: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Per conto di Munoz, Alvaro
	Inviato: martedì 18 dicembre 2007 13.52
	A: RT Users
	Oggetto: [rt-users] Quey to match cf not filled
	
	
	Hi,
	 
	Im trying to match all the tickets with a customfield not filled up. Im using this query but its not working. any hints?
	 
	( Status = 'open' AND Queue = 'Incidents' AND 'CF.{Report}' != '' )
	 
	Thanks in advance,
	Regards
	Alvaro
	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071218/de3c8669/attachment.htm>