[Solved] Changing a bool field to display Yes No

[Shane P]

I am trying to display a boolean field as Yes?No vs true or false.

I have got this far

.Columns(columns =>
{
    columns.Command(commands =>
    {
        commands.Select().ButtonType(GridButtonType.Text);
    }).Width(80).Title("Publish");
    columns.Bound(o => o.Version).Width(80);
    columns.Bound(o => o.LastModified).Format("{0:dd-MM-yyyy hh:mm tt}");
    columns.Bound(o => o.Published).Template(o =>
                                             o.Published ? "Yes" : "No"
                                            );

The grid loads ok however the template hasn't been applied. Can anyone see what I am doing wrong?

Thanks
Shane

[Atanas Korchev]

Hi Shane P,

 Try this:

Template(o =>
{
%>

   <%= o.Published ? "True" : "False" %>

<%
});

Regards,
Atanas Korchev
the Telerik team

[Shane P]

Hi Atanas,
Sorry forgot to mention that im using razor. So your example wont work for me.

[Atanas Korchev]

Hello Shane P,

 The Razor syntax is this:

.Template(@<text>
                @(item.Published ? "True" : "False")
</text>);

Regards,
Atanas Korchev
the Telerik team

[Shane P]

Hi Atanas,

Is this a bug with the latest release? as I have tried to use your suggestion however im only seeing either true or false

My binding of the columns looks like this

.Columns(columns =>
    {
        columns.Bound(o => o.ID).ClientTemplate("<a href='" + Url.Content("~/businessaccount/publish/<#= ID #>") + "' class='t-button t-grid-select'>Publish</a>").Title("Publish").Width(80);
        columns.Bound(o => o.Version).Width(80);
        columns.Bound(o => o.LastModified).Format("{0:dd-MM-yyyy hh:mm tt}");
        columns.Bound(o => o.Published).Template(@<text>
                                                 @(item.Published ? "True" : "False")
                                                 </text>);
    })

[Atanas Korchev]

Hello Shane P,

There is no bug. The code is explicitly returning "True" or "False". I now see that you wanted "Yes" or "No" to be displayed. To do so just change the strings:

.Columns(columns =>
    {
        columns.Bound(o => o.ID).ClientTemplate("<a href='" + Url.Content("~/businessaccount/publish/<#= ID #>") + "' class='t-button t-grid-select'>Publish</a>").Title("Publish").Width(80);
        columns.Bound(o => o.Version).Width(80);
        columns.Bound(o => o.LastModified).Format("{0:dd-MM-yyyy hh:mm tt}");
        columns.Bound(o => o.Published).Template(@<text>
                                                 @(item.Published ? "Yes" : "No")
                                                 </text>);
    })

Best wishes,
Atanas Korchev
the Telerik team

[Shane P]

I must be doing something wrong as even if I use your example with True or False (note the capitals) the grid it returning only true or false in lowercase. 

My full code for my grid looks like

      @{ Html.Telerik().Grid<SP.Models.WebPageModel>()

.Name("Grid")

.DataKeys(dataKeys => dataKeys.Add(c => c.WebPageID))

.ClientEvents(e => e.OnLoad("Grid_OnLoad"))

.ToolBar(commands => commands.Custom().ButtonType(GridButtonType.Text).Action("create", "webpage").Text("Create Web Page").ImageHtmlAttributes(new { style = "margin-left:0" }))

.Columns(columns =>

{

    columns.Bound(o => o.ID).ClientTemplate("<a href='" + Url.Content("~/businessaccount/publish/<#= ID #>") + "' class='t-button t-grid-select'>Publish</a>").Title("Publish").Width(80);

    columns.Bound(o => o.Version).Width(80);

    columns.Bound(o => o.LastModified).Format("{0:dd-MM-yyyy hh:mm tt}");

    columns.Bound(o => o.Published).Template(@<text>

                                             @(item.Published ? "Yes" : "No")

                                             </text>);

})

 

 

.DataBinding(dataBinding => dataBinding

                              .Ajax()

                              .Select("GetWebPages", "BusinessAccount", new { id = (string)ViewData["id"] })

                              )

 

.Sortable()

.RowAction(row => row.Selected = row.DataItem.WebPageID.Equals(ViewData["id"]))

.Pageable()

.Footer(true)

.Render(); }




Do I need to reference some other js library or something to enable changing the template?

[Atanas Korchev]

Hi Shane P,

 Your grid seems to be ajax bound (this was not specified before)- server templates are not applied during ajax binding and you need to use a client template:

.ClientTemplate("<#= Published? 'Yes' : 'No' #>")

Regards,
Atanas Korchev
the Telerik team

[Coding Machine]

Correct sample is (without tag brackets):

         columns.Bound(x => x.Active).ClientTemplate("#= Active? 'Yes' : 'No' #");