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 Online
-----Original Message-----
From: John H. Nyhuis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 10:42 AM
To: Schultz, Eric
Cc: [email protected]
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
[EMAIL PROTECTED]
On Wed, 12 Jul 2006, Schultz, Eric wrote:
> What version of RT?
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John H.
> Nyhuis
> Sent: Wednesday, July 12, 2006 2:58 PM
> To: [email protected]
> 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
> [EMAIL PROTECTED]
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> 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
>
>
> We're hiring! Come hack Perl for Best Practical:
> http://bestpractical.com/about/jobs.html
>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
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
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
