A custom field shows inconsistent results in a query. Here is the source:
Here is the result in the query:
Why does A. show "false" and A.F. show nothing? Based upon the source, should not A.F. show "false", too?
What Prevents Data From Appearing in a Query
This is a known issue that Zendesk doesn't consider a bug. I filed a feature request because it's absolute madness to have checkboxes have more than two possible values. For whatever reason, the system decided that A.F. in your example was set to "NULL" not "FALSE" in this instance, so it's both not true, and not False. This happens all the time, to all checkboxes, both ticket field and user, and makes reporting on them incredibly fussy and difficult. I wish I had a solution better than this, but one thing you can do is consider NULL as also false. You can write a custom formula to make NULL output to "False" as well, if you need to use the checkbox for a filter on reporting and don't want people getting confused.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.