jQuery UI Widgets › Forums › Grid › JSON string rendering
Tagged: datagridview, jqxgrid, row details
This topic contains 4 replies, has 2 voices, and was last updated by sergeyr 11 years, 12 months ago.
-
AuthorJSON string rendering Posts
-
Hello.
I have to render stringified JSON object, how can I implement this?
I tried cellsrenderer option of columns property but the value that comes there is already just string ‘[object Object]’
Should i do smth with dataAdapter?var wikiExamplesSource = { datatype: "json", datafields: [ { name: 'exampleName'}, { name: 'exampleJson'} ], root: "jsonExample", localdata: wikiJSON };var wikiExampleDataAdapter = new $.jqx.dataAdapter(wikiExamplesSource);$("#wikiExampleTable").jqxGrid( { width: 670, height: 250, source: wikiExampleDataAdapter, theme: theme, rowdetails: true, rowdetailstemplate: { rowdetails: "<div> See this? </div>", rowdetailsheight: 200 }, ready: function () { $("#wikiExampleTable").jqxGrid('showrowdetails', 0); $("#wikiExampleTable").jqxGrid('showrowdetails', columns : [ { text : 'Message name', datafield : 'exampleName', width : 250 }, { text : 'Example', datafield : 'exampleJson', cellsrenderer: function (row, columnfield, value, defaulthtml, columnproperties) { return JSON.stringify(value); } , width : 250 } ], });
Hi sergeyr,
What is the JSON that you want to load in jqxGrid? The provided code is not enough for testing the reported behavior.
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.comvar wikiJSON = { "id":"507d51c1e51bd01492f38e03", "key":"UMS-AuthenticationService-Login", "title":"Login to UMS Message", "description":"This is description for UMS Login message", "fields":[ { "name":"username", "description":"represents username", "type":"String", "required":true }, { "name":"password", "description":"represents password", "type":"String", "required":true } ], "jsonExample":[ { "exampleName":"Login Request", "exampleJson":{ "userName":"YODA116" } }, { "exampleName":"Login Response", "exampleJson":{ "token":{ "secretKey":"F53615B2BBB5A99B9D416C5AA3954F19" }, "ID":10002 } } ], "diagramText":":actor :OpenAPI OpenAPI>getTemporaryAuthenticationTokenRequest(10001){actor>getTemporaryAuthenticationTokenResponse(10002)}", "author":"L. N. Tolstoy", "build":"1.0.0", "vresion":null}
Hi sergeyr,
Here’s a working code:
<!DOCTYPE html><html lang="en"><head> <link rel="stylesheet" href="../../jqwidgets/styles/jqx.base.css" type="text/css" /> <script type="text/javascript" src="../../scripts/jquery-1.8.2.min.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxcore.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxdata.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxbuttons.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxscrollbar.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxmenu.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxgrid.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxgrid.selection.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxtabs.js"></script> <script type="text/javascript" src="../../scripts/gettheme.js"></script> <script type="text/javascript"> $(document).ready(function () { var theme = getTheme(); // prepare the data var data = new Array(); var wikiJSON = { "id": "507d51c1e51bd01492f38e03", "key": "UMS-AuthenticationService-Login", "title": "Login to UMS Message", "description": "This is description for UMS Login message", "fields": [ { "name": "username", "description": "represents username", "type": "String", "required": true }, { "name": "password", "description": "represents password", "type": "String", "required": true } ], "jsonExample": [ { "exampleName": "Login Request", "exampleJson": { "userName": "YODA116" } }, { "exampleName": "Login Response", "exampleJson": { "token": { "secretKey": "F53615B2BBB5A99B9D416C5AA3954F19" }, "ID": 10002 } } ], "diagramText": ":actor :OpenAPI OpenAPI>getTemporaryAuthenticationTokenRequest(10001){actor>getTemporaryAuthenticationTokenResponse(10002)}", "author": "L. N. Tolstoy", "build": "1.0.0", "vresion": null }; var wikiExamplesSource = { datatype: "json", datafields: [ { name: 'exampleName' }, { name: 'exampleJson', map: 'exampleJson>userName' } ], root: "jsonExample", localdata: wikiJSON }; var wikiExampleDataAdapter = new $.jqx.dataAdapter(wikiExamplesSource); $("#wikiExampleTable").jqxGrid( { width: 670, height: 250, source: wikiExampleDataAdapter, theme: theme, rowdetails: true, rowdetailstemplate: { rowdetails: "<div> See this? </div>", rowdetailsheight: 200 }, ready: function () { $("#wikiExampleTable").jqxGrid('showrowdetails', 0); }, columns: [{ text: 'Message name', datafield: 'exampleName', width: 250 }, { text: 'Example', datafield: 'exampleJson', cellsrenderer: function (row, columnfield, value, defaulthtml, columnproperties) { return JSON.stringify(value); } } ], }); }); </script></head><body class='default'> <div id='jqxWidget' style="font-size: 13px; font-family: Verdana; float: left;"> <div id="wikiExampleTable"></div> </div></body></html>
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.comthanks, that works , but I wonder if there is any way to render all the JSON as string, in particular – all the ‘exampleJson’ fields, like:
{ "token": { "secretKey": "F53615B2BBB5A99B9D416C5AA3954F19" }, "ID": 10002 }
-
AuthorPosts
You must be logged in to reply to this topic.