[rt-users] Q: build a ticket query that selects empty custom fields

[Schultz, Eric]

What version of RT? 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of John H.
Nyhuis
Sent: Wednesday, July 12, 2006 2:58 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Q: build a ticket query that selects empty custom
fields

 	Greetings,

 	I am trying to build a ticket query that will select all tickets

that have a custom field that did not get filled in by our field techs. 
The custom field I am interested in is a text area.
 	I have tried a variety of combinations (such as less then 1 and 
white space of various types) but 
empty fields are not considered, and so are not selected.
 	Has anyone figured out how to do this and would be willing to 
share?

 	Thanks in advance,

John H. Nyhuis
Sr. Computer Specialist
Dept. of Pediatrics
HS RR349B, Box 356320
University of Washington
Desk: (206)-685-3884
cabal at u.washington.edu
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html