You didn’t saw what version of 3.4. Shall I assume 3.4.0? In 3.4.4,
lib/RT/Tickets_Overlay.pm was fixed such that you could do this query.
The relevant code appears to be:
my $null_columns_ok;
! if ( ( $op =~ /^IS$/i ) or ( $op =~ /^NOT LIKE$/i ) or ( $op eq
‘!=’ ) ) {
$null_columns_ok = 1;
}
changed to:
my $null_columns_ok;
! if ( ( $op =~ /^NOT LIKE$/i ) or ( $op eq ‘!=’ ) ) {
$null_columns_ok = 1;
}
Hope that helps.
Eric Schultz
United OnlineFrom: John H. Nyhuis [mailto:cabal@u.washington.edu]
Sent: Thursday, July 13, 2006 10:42 AM
To: Schultz, Eric
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Q: build a ticket query that selects empty
custom fields
Sorry, RT version is 3.4 on FreeBSD, using Apache 1.3 +modssl
+modperl and MySQL.
Thanks,
John H. Nyhuis
Sr. Computer Specialist
Dept. of Pediatrics
HS RR349B, Box 356320
University of Washington
Desk: (206)-685-3884
cabal@u.washington.edu
What version of RT?
-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of John H.
Nyhuis
Sent: Wednesday, July 12, 2006 2:58 PM
To: rt-users@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@u.washington.edu
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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:
Careers — Best Practical Solutions