Mailing List Archive

Searching for tickets with empty CF in RT 4.2.8
Hello,

I have some saved searches on my dashboard. Three of them are based on a Custom Field; one show tickets where the CF is set to X, one where CF is set to Y, and one is supposed to show tickets tagged with something other then X or Y.
To make the third search, I created the following search;
Queue = 'foo'
AND CF.{bar} != 'X'
AND CF.[bar] != 'Y'
AND (
Status = 'new'
OR Status = 'open'
OR Status = 'stalled' )

However, tickets marked with either X or Y are still appearing in the result. The same result was returned if i changed != to "NOT LIKE", and if I removed either the X or Y part.

Is this a bug, is there something wrong with our RT instance or is there something I've overlooked?
The operator 'IS' works fine, but it would be nice if I didn't have to change a query each time I updated a Custom Field..

Best regards,
Thomas Oddsund
SDS/USIT
University of Oslo
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Searching for tickets with empty CF in RT 4.2.8 [ In reply to ]
Hi Thomas,

On Fri, Dec 9, 2016 at 4:53 AM, Thomas Oddsund
<thomas.oddsund@usit.uio.no> wrote:
> Hello,
>
> I have some saved searches on my dashboard. Three of them are based on a Custom Field; one show tickets where the CF is set to X, one where CF is set to Y, and one is supposed to show tickets tagged with something other then X or Y.
> To make the third search, I created the following search;
> Queue = 'foo'
> AND CF.{bar} != 'X'
> AND CF.[bar] != 'Y'
> AND (
> Status = 'new'
> OR Status = 'open'
> OR Status = 'stalled' )
>
> However, tickets marked with either X or Y are still appearing in the result. The same result was returned if i changed != to "NOT LIKE", and if I removed either the X or Y part.
>
> Is this a bug, is there something wrong with our RT instance or is there something I've overlooked?

I'm not sure about answering this question, but you can search for
tickets with empty CF values using the Advanced editing option of a
Search:

'CF.{bar}' is null

-m
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Searching for tickets with empty CF in RT 4.2.8 [ In reply to ]
Hello,

Thanks for your response Matt. Unfortunately, that doesn't help, as I have another search for that(new tickets doesn't have any value in the CF, and the CF is set manually once the ticket is taken).

Best regards,
Thomas Oddsund
RT/SDS/USIT

________________________________________
Fra: Matt Zagrabelny <mzagrabe@d.umn.edu>
Sendt: 9. desember 2016 15:23
Til: Thomas Oddsund
Kopi: rt-users@lists.bestpractical.com
Emne: Re: [rt-users] Searching for tickets with empty CF in RT 4.2.8

Hi Thomas,

On Fri, Dec 9, 2016 at 4:53 AM, Thomas Oddsund
<thomas.oddsund@usit.uio.no> wrote:
> Hello,
>
> I have some saved searches on my dashboard. Three of them are based on a Custom Field; one show tickets where the CF is set to X, one where CF is set to Y, and one is supposed to show tickets tagged with something other then X or Y.
> To make the third search, I created the following search;
> Queue = 'foo'
> AND CF.{bar} != 'X'
> AND CF.[bar] != 'Y'
> AND (
> Status = 'new'
> OR Status = 'open'
> OR Status = 'stalled' )
>
> However, tickets marked with either X or Y are still appearing in the result. The same result was returned if i changed != to "NOT LIKE", and if I removed either the X or Y part.
>
> Is this a bug, is there something wrong with our RT instance or is there something I've overlooked?

I'm not sure about answering this question, but you can search for
tickets with empty CF values using the Advanced editing option of a
Search:

'CF.{bar}' is null

-m
---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017