Skip to main content

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?

@avandervelden Is 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.


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💪


Reply