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

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
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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:

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.eduOn Wed, 12 Jul 2006, Schultz, Eric wrote:

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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:
http://bestpractical.com/about/jobs.html

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


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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:
http://bestpractical.com/about/jobs.html