[rt-users] IS NULL vs = 'null'

Jesse Vincent jesse at bestpractical.com
Mon Sep 20 15:07:54 EDT 2004


Which 3.2.x are you running? It might be worth giving 3.2.2rc1 a shot, 
as there have been some logic fixes on search...
	Jesse
On Sep 20, 2004, at 2:19 PM, Tony Bowden wrote:

>
> We finally managed to upgrade to 3.2
>
> And, now all my bookmarks are broken :(
>
> So I tried to rebuild all my searches. But some of them I can't get to
> work at all.
>
> In particular, we have a custom field for Client. And I had a search
> that lists all the tickets that had no value set for this.
>
> However, when I try to build this query now, it always returns 0
> results. It appears to be turning
>   Client is (no value)
> into
>   'CF.Client' = 'null'
> rather than
>   'CF.Client' IS NULL
>
> Am I missing something obvious, or is this a bug?
>
> Tony
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
>




More information about the rt-users mailing list