<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=328184613-18122007><FONT face=Arial
color=#0000ff size=2>from the gui?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=328184613-18122007><FONT face=Arial
color=#0000ff size=2>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:</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2>is </FONT></SPAN><SPAN
class=328184613-18122007><FONT face=Arial color=#0000ff size=2>(no
value)</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff size=2>that
when you add translates at right side to</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff size=2>AND
'CF.{Report}' IS 'NULL'</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff size=2>On the
contrary you can select "isn't" to get all the tickets with the CF filled up
with something.</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2>HIH,</FONT></SPAN></DIV>
<DIV><SPAN class=328184613-18122007><FONT face=Arial color=#0000ff
size=2>Gianluca</FONT></SPAN></DIV>
<DIV dir=ltr align=left><BR></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=it dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Da:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>Per conto di </B>Munoz,
Alvaro<BR><B>Inviato:</B> marted́ 18 dicembre 2007 13.52<BR><B>A:</B> RT
Users<BR><B>Oggetto:</B> [rt-users] Quey to match cf not
filled<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>Im trying to match all the
tickets with a customfield not filled up. Im using this query but its not
working. any hints?</FONT></SPAN></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>( Status = 'open' AND Queue =
'Incidents' AND 'CF.{Report}' != '' )</FONT></SPAN></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>Thanks in
advance,</FONT></SPAN></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=579305012-18122007><FONT size=2>Alvaro</FONT></SPAN></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>