数据未显示在数据表中 [英] Data not displaying in Data table

问题描述

嗨Jovan Popovic，



正如你所说，我以熟悉的方式尝试

Hi Jovan Popovic,

As u said i tried in the smiliar way

$("#jQueryInvoices").dataTable({
"bServerSide": true,
"sAjaxSource": "/audit/listinvoice.do?action=getInvoices&carrierId=22&customerId=12096&shipperId=-1&status=Open&invoiceNumber=&toDateStr=&fromDateStr=&controlNumber=&runNumber=&dateCriteria=billDate&glCode=-1",
"bProcessing": true,
"sPaginationType": "full_numbers",
"bJQueryUI": true,
"aoColumns": [
{ "mDataProp": "invoiceNumber" },
{ "mDataProp": "invoiceAmount" },
{ "mDataProp": "contractNumber" },
{ "mDataProp": "status" }
]
});
}

和Html我构建表格为：

and in Html i build table as:

<div id="demo_jui">
    <table id="jQueryInvoices"  class="display">
        <thead>
            <tr>
                <th>Invoice Number</th>
                <th>Invoice Amount</th>
                <th>Contract Number</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>

我收到来自服务器的回复：

I'm getting response from server as :

{"aaData":[
{"invoiceAmount":92.67,
customerId":12096,"
contractNumber":"11
status":"Open","
invoiceId":9715002,"
billDate":"09/16/2013","
invoiceNumber":"240198645","
lastUpdateDate":"09/15/2013","
fromLiveDB":true,"
sumApprovedAmt":48.86,"
shipperCode":"239253008","
closedCount":16}

但我的数据表是仅显示表头，不显示任何数据。在这里作为响应我将完成bean对象，但我必须只显示特定的列，我在oColumns属性中提到了那些。你可以帮我解决这个问题吗？

but my data table is showing only with table headers , no data is displayed. Here in response i will complete bean object ,but i have to display only specific columns and i mentioned those in oColumns attribute. Could you please help me out on this where i went wrong??

推荐答案

（ #jQueryInvoices）。dataTable（{
bServerSide ： true ，
sAjaxSource： / audit / listinvoice.do？action = getInvoices& carrierId = 22& customerId = 12096& ; shipperId = -1& status = Open& invoiceNumber =& toDateStr =& fromDateStr =& controlNumber =& runNumber =& dateCriteria = billDate& glCode = -1，
b处理： true ，
sPaginationType： full_numbers，
bJQueryUI： true ，
aoColumns：[
{ mDataProp： < span class =code-string> invoiceNumber}，
{ mDataProp： invoiceAmount}，
{ mDataProp： contractNumber }，
{ mDataProp： status}
]
}）;
}

("#jQueryInvoices").dataTable({ "bServerSide": true, "sAjaxSource": "/audit/listinvoice.do?action=getInvoices&carrierId=22&customerId=12096&shipperId=-1&status=Open&invoiceNumber=&toDateStr=&fromDateStr=&controlNumber=&runNumber=&dateCriteria=billDate&glCode=-1", "bProcessing": true, "sPaginationType": "full_numbers", "bJQueryUI": true, "aoColumns": [ { "mDataProp": "invoiceNumber" }, { "mDataProp": "invoiceAmount" }, { "mDataProp": "contractNumber" }, { "mDataProp": "status" } ] }); }

和Html我构建表格为：

and in Html i build table as:

<div id="demo_jui">
    <table id="jQueryInvoices"  class="display">
        <thead>
            <tr>
                <th>Invoice Number</th>
                <th>Invoice Amount</th>
                <th>Contract Number</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>

我收到来自服务器的回复：

I'm getting response from server as :

{"aaData":[
{"invoiceAmount":92.67,
customerId":12096,"
contractNumber":"11
status":"Open","
invoiceId":9715002,"
billDate":"09/16/2013","
invoiceNumber":"240198645","
lastUpdateDate":"09/15/2013","
fromLiveDB":true,"
sumApprovedAmt":48.86,"
shipperCode":"239253008","
closedCount":16}

但我的数据表是仅显示表头，不显示任何数据。在这里作为响应我将完成bean对象，但我必须只显示特定的列，我在oColumns属性中提到了那些。你可以帮我解决一下我出错的地方吗？

but my data table is showing only with table headers , no data is displayed. Here in response i will complete bean object ,but i have to display only specific columns and i mentioned those in oColumns attribute. Could you please help me out on this where i went wrong??

这篇关于数据未显示在数据表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！