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

Duncan Hutty dhutty at allgoodbits.org
Tue Jun 26 10:48:46 EDT 2012


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



More information about the rt-users mailing list