Skip to main content
Solved

Aggregation Sum on checkbox in Universal GUI


Forum|alt.badge.img+5

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?

Best answer by Anne Buit

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💪

View original
Did this topic help you find an answer to your question?

3 replies

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


Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 653 replies
  • Answer
  • May 9, 2025

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💪


Forum|alt.badge.img+3

Hi,

This issue should be fixed in the next version of Indicium (2025.1.15.0). I expect this version to become available on 06/30/2025

Regards,

Dick van den Brink


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings