IS NULL vs = 'null'

RT Users
1

We finally managed to upgrade to 3.2

And, now all my bookmarks are broken :frowning:

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

2

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…
JesseOn 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 :frowning:

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

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

3

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…

3.2.1. Having finally gotten it migrated to a debian box, I think we’re
quite keen to try to keep it in sync with them …

Tony

4

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…

3.2.1. Having finally gotten it migrated to a debian box, I think we’re
quite keen to try to keep it in sync with them …

Well, when you upgrade to 3.2.2, tell us if that fixes the issue. Or
submit some failing tests :wink:

Best,
Jesse