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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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