[Solved] Sort on a template column?

[William Brown]

I have checkbox column in a grid and want the uses to be able to sort if it's checked or not.  Is there a way to use a gridbuilder type on the grid to be able to allow sorting on that column?

[Georgi Krustev]

Hello William Brown,

 I will suggest you examine this online demo, which shows how to sort column with boolean type.

All the best,
Georgi Krustev
the Telerik team

[William Brown]

But can you sort on a template colum?

 

our column is a template column that toggles and saves the value.  This removes the sort on that column.  Can you sort on a template column like this?  I couldn't see how in the link you suggest I look at. thanks Georgi

 

columns.Template(o => {
               %>
                   <input type="checkbox" id="IsLockedOut" name="IsLockedOut"
                   <% if (o.IsLockedOut) { %>
                       checked="checked"
                   <%} %>
                    onclick="OnLockedOutToggle('<%= o.UserName %>')" />
               <%
               })
               .Width(30)
               .Title("IsLockedOut")
               .HtmlAttributes(new { align="center" });

[Georgi Krustev]

Hello William Brown,

In the way how the column is declared, grid does not know on which property to sort. In order to achieve your goal you need to add Bound column with server template:

columns.Bound(o => o.IsLockedOut)
       .Template(x => {
               %>
                   <input type="checkbox" id="IsLockedOut" name="IsLockedOut"
                   <% if (o.IsLockedOut) { %>
                       checked="checked"
                   <%} %>
                    onclick="OnLockedOutToggle('<%= o.UserName %>')" />
               <%
               })
               .Width(30)
               .Title("IsLockedOut")
               .HtmlAttributes(new { align="center" });

All the best,
Georgi Krustev
the Telerik team

[William Brown]

Thanks Georgi!

Works perfectly. I had to change o. to x. under the template if statements, but it is what we were looking for.

Bill