使用 Visualforce 页面中的数据填充 jqgrid

发布于 2024-09-10 10:25:12 字数 1078 浏览 9 评论 0原文

我有一个 Visualforce 页面，我正在使用 jqgrid 在此页面上显示数据。 jqgrid指向的url是一个visualforce页面(https://test.visual.force。 com/apex/GridResults），仅输出 JSON 数据。该页面没有任何标题或 html 信息。

问题是，当我运行此页面时，网格呈现列名称，但没有数据。当我运行 url 时，它会输出 JSON 数据。我已将代码粘贴在下面。

   jQuery("#list").jqGrid({
        url:"https://test.visual.force.com/apex/GridResults",
        datatype: "json",
        colNames: [{!fieldNames}], -- property in controller  which outputs fieldnames 
        colModel: [{!colModel}], -- property in controller which outputs column definition
        rowNum: 10,
        rowTotal:10,
        rowList: [20, 40, 60],
        loadonce:true,
        mtype:"GET",
        gridView:true,
        pager: '#pager',
        sortname: 'Record ID',
        sortorder: "desc",
        width: 1200,
        height: 400,
        caption: "Accounts"
    });  
    jQuery("#list").jqGrid('navGrid', "#pager", { edit: true, add: true, del: false })
    };

关于为什么 jqgrid 不消耗页面数据的任何想法？非常感谢帮助。

原文

I have a visualforce page and I am using jqgrid to display data on this page. The url that the jqgrid points to is a visualforce page(https://test.visual.force.com/apex/GridResults) which outputs only JSON data. This page does not have any header or html information.

The problem is that when I run this page, the grid renders with column names but no data.
When I run the url it outputs JSON data. I have pasted below the code.

   jQuery("#list").jqGrid({
        url:"https://test.visual.force.com/apex/GridResults",
        datatype: "json",
        colNames: [{!fieldNames}], -- property in controller  which outputs fieldnames 
        colModel: [{!colModel}], -- property in controller which outputs column definition
        rowNum: 10,
        rowTotal:10,
        rowList: [20, 40, 60],
        loadonce:true,
        mtype:"GET",
        gridView:true,
        pager: '#pager',
        sortname: 'Record ID',
        sortorder: "desc",
        width: 1200,
        height: 400,
        caption: "Accounts"
    });  
    jQuery("#list").jqGrid('navGrid', "#pager", { edit: true, add: true, del: false })
    };

Any ideas on why the data from the page is not consumed by the jqgrid? Help much appreciated.

分享到QQ

分享到微博