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

[Schultz, Eric]

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:cabal at u.washington.edu] 
Sent: Thursday, July 13, 2006 10:42 AM
To: Schultz, Eric
Cc: rt-users at 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 at u.washington.edu

On Wed, 12 Jul 2006, Schultz, Eric wrote:

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