Kendo Grid - replace existing value with new

[Kirubakaran]

Below is my coding.

Here i want to do a if condition in "Comments" column. if comments available then i need to replace it as "1". if its empty then "0".

1. Either i can introduce new column at the end and apply the above condition and hide the "Comment" column (as this value depend on child row)

2. or directly modify the comment column

 

<div id="grid"></div>
                    <button id="btnprint" type="submit" name="excel" value="valexcel">Print</button>
<script> $("#grid").kendoGrid({ columns: [{ field: "productName" }, { field: "category" }, { field: "status" }, { field: "Comments" }], dataSource: { data: [{ productName: "Tea", category: "Beverages", status: "Open", "Comments": "" }, { productName: "Coffee", category: "Beverages", status: "Open", "Comments": "comment1" }, { productName: "Ham", category: "Food", status: "Open", "Comments": "" }, { productName: "Bread", category: "Food", status: "Open", "Comments": "" }, { productName: "Hammer", category: "Hardware", status: "Closed", "Comments": "Comment test" }, { productName: "Screw", category: "Hardware", status: "Open", "Comments": "commenting testing" }], group: { field: "category" } },  detailTemplate: "<div class='Comments'>",
                    detailInit: function (e) { e.detailRow.find(".Comments").html("<p>" + e.data.Comments + "</p>"); }, });</script>

[Silviya Stoyanova]

Hello Kirubakaran,

 

I would suggest adding a template to the column "Comments", where to apply the conditional clause for available comments.

You can see a runnable example here.

 

Kind Regards, Silviya Stoyanova Progress Telerik

[Kirubakaran]

Thanks Silviya.