Aggregation Sum on checkbox in Universal GUI

Question

In Windows it is possible to do a sum on a “checkbox”, where the domain is INT   In the Universal GUI, this doesn't work Would be very nice if this option will also work in Universal GUI….ef_evnt_event_staff_planning?$apply=aggregate(count_using_dinner%20with%20sum%20as%20count_using_dinner_sum)Results in 500 error :-(.Is there a way to make that work?

Anne Buit · Accepted Answer

If this is the root cause, please create an Indicium ticket for this.This should be supported out-of-the-box without having the convert the datatype yourself💪

Mark_Plaggenborg · Answer

​@avanderveldenIs the screen you are showing by any chance a “view”? It could be that the definition is seeing it as perhaps a BIT (or another data type) instead of a TINYINT.If so, use a CAST() or CONVERT() to make it match.Example to use for specific column in your Control Procedure template of your view:CAST(0 AS TINYINT)I also get a 500 error when I CAST() it as a BIT.

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded