Grouping by bool datatype

[Flemming]

Hi,

 

Can I use groupBy for a column of boolean datatype?

like this:

const datasource = groupBy(s.value, [{field: 'MyBoolProperty'}]);

 

I am trying to pass this to a Dropdownlist and it works if the column is a string typed column.

 

Best regards

Flemming Christiansen

[Alexander Valchev]

Hi Flemming,

The DataQuery itself supports grouping by boolean field, but the DropDownList expects string value in the grouped by field. You will encounter the same problem if you try to group by a number field.

A simple workaround is to map the data and manually convert the boolean/number into string. Here's a quick demo that demonstrates the approach in action:

• https://stackblitz.com/edit/angular-vptrsw?file=app/app.component.ts

I hope this will help.

Regards,
Alexander Valchev
Progress Telerik