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

Schultz, Eric ESchultz at corp.untd.com
Wed Jul 12 17:59:28 EDT 2006

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.
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


 	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 

 	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

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:

More information about the rt-users mailing list