This is a migrated thread and some comments may be shown as answers.

Boolean data type in Grid data source

4 Answers 527 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Philip asked on 02 Dec 2011, 08:35 PM

I have 3 columns returning with my data source that are Boolean values (True/False). I couldn't figure out how to designate them as a data type of Boolean to actually evaluate them, so I'm bringing them back as strings and evaluation them as == "True" or "False".

Is it possible to return them to the grid control as actual Booleans and evaluate them as such?

dataSource: {

data:

[

@foreach (var report in Model.Reports)

{

<text

>{Id: @report.Id, ReportId: "@report.ReportId", ReportSample: "@report.ReportSample", ReportLegend: "@report.ReportLegend", ReportFaq: "@report.ReportFaq", ReportName: "@report.ReportName"}, </

text>

}

],

schema: {

model: {

id: "Id",

fields: {

Id: { type: "number" },

ReportId: { type: "string" },

ReportSample: { type: "string" },

ReportLegend: { type: "string" },

ReportFaq: { type: "string" },

ReportName: { type: "string" }

}

I currently have quotes around the Boolean values being returned:
"@report.ReportSample", "@report.ReportLegend", "@report.ReportFaq"
removing the quotes causes the grid to not display

Thanks for the assistance

4 Answers, 1 is accepted

answered on 02 Dec 2011, 08:59 PM

dataSource: {

data: Model.Reports,

schema: {

model: {

id: "Id",

fields: {

Id: { type: "number" },

ReportId: { type: "string" },

ReportSample: { type: "string" },

ReportLegend: { type: "string" },

ReportFaq: { type: "string" },

ReportName: { type: "string" }

}

},

      columns: [

{field: 'Id', title: 'Report Num' },

{field: 'ReportSample', title: 'Sample' }, 

{field: 'ReportLegend', title: 'Legend', template: '<input type="checkbox" checked="#= ReportLegend #" disabled="disabled" /> }, 

{field: 'Id', title: 'Report Num' }, 

{field: 'ReportName', title: 'Name' }, 



	]

}