[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