[rt-users] matching null against date/datetime CustomFields

[Ruslan Zakirov]

Hi,

Try "CF.{xxx} IS NULL", but it may fail. File a bug report if it fails.

On Tue, Jun 26, 2012 at 5:48 PM, Duncan Hutty <dhutty at allgoodbits.org> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> In RT4, we can create Custom Fields that have date or datetime types.
>
> If a date/datetime Custom Field has not been set, it displays as :
> CFNAME: (no value)
>
> How do I search for tickets that have not had a value set into that
> Custom Field?
>
> Here's what I have tried:
>
> CF.{myfieldname} = ''
> CF.{myfieldname} = 'NULL'
> CF.{myfieldname} = 'undef'
> CF.{myfieldname} = 0
> CF.{myfieldname} = '1970-01-01 00:00:00'
>
> If it is _not_ possible to search for null, doesn't that break the
> semantics of a date/datetime comparison?
> - --
> Duncan Hutty
> http://www.allgoodbits.org
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAk/py84ACgkQCFuTFybf1wp/XgCghUI3Nu9wV0iQJCMibpmXvxdO
> T5sAoKNezJxQY8/dmwTFb9uTMR4+57Je
> =VNVX
> -----END PGP SIGNATURE-----



-- 
Best regards, Ruslan.