Table claims "no matching results" unsure why.
Table claims "no matching results" unsure why.
RainJar
Posts: 3Questions: 2Answers: 0
Hey guys, at the moment we have a Server-Side table set up and we have it coming back with results on the server end, passing them over seeming with results in the json, but throwing no results in the datatable.
The Json being returned is
{
"draw":1,
"recordsFiltered":16,
"recordsTotal":16,
"data":[
{
"type":"PAY",
"date":"28/02/2017",
"outstanding":1965.0,
"salesOrderNumber":828877,
"net":1965.0,
"tax":0.0,
"gross":1965.0,
"dueDate":"01/01/0001"
},
there is a hell of a lot more so this is just a snap of the top, have checked it through a validator and it is valid, complete json.
we have javascript setting up the table like listed below
"columns": [
{ "data": "type" },
{ "data": "date" },
{ "data": "dueDate" },
which from what I am aware is making use of the "data" section of the json right?
not too sure what is wrong as the recordsTotal and pagination seem to display and work fine, though there are no results actually loading on the table.