Quey to match cf not filled

RT Users
1

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

2

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@lists.bestpractical.com [mailto:rt-users-bounces@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