Kendo UI Grid - Custom filter with multi checkbox on boolean field

[Prakash]

I have two boolean columns named "IsActive" and "IsDeleted" in the database table. The column "IsActive" indicates whether the user is Active or Deactive, and the column "IsDeleted" for soft deletion. Now I want to have a single column called "Status" with filter options as multiple checkbox as Active, Deactive and Delete. How can I implement this filter column in the grid? I have attached the screenshot for your reference.

[Boyan Dimitrov]

Hello Prakash,

 

Since the status field does not exists in the data table, an additional field should be added to the response coming from the server. The best option for this is to use the schema.parse that is executed before the server response is used. It could be used to preprocess the data before passed to the Kendo UI DataSource. 

 

Basically you can add an additional field "status" to the response and bind a column of the grid to that field. The field will have three possible values : "activated", "deactivated" and "deleted". 

 

In order to show the check boxes in the filter menu you can enable the multi filter check box for the "status" column as shown in the Grid / Filter Multi Checkboxes demo. 

 

Regards,
Boyan Dimitrov
Telerik

 

 

[Prakash]

That's great. Thanks for the idea.