Matching null against date/datetime CustomFields

-----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-----

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@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.