What Prevents Data From Appearing in a Query
回答済み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?
-
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.
-
CJ Johnson,
Thanks for the info. I'll look into the custom formula.Mark
サインインしてコメントを残してください。
2 コメント