i don't think i know what script you're referring to.
The script that is called in the Datatables AJAX URL. That is the script making the query and returning the data. Sounds like the query needs to be modified to include the additional fields you want displayed in the child detail rows.
A good way would be to check the network tab on the developer area of the browser, then you can see what the server is sending to the webclient. You could also try JSON.stringify(d), that would show the contents of the object.
What Kevin and I have been trying to understand is whether the object being returned, matches what you're you expect it to be. In your format function, you're accessing d.explanation and d.groovydoc, so we'd expect to see those properties inside the objects being returned.
Answers
i get all the fields when i use a json file. but here my data is in a database.
all my fields are in one db table.
Your server script’s db query is the ace to look. Does it include the fields you want?
i think so. if i select * in a query of that table, i get all the columns i need.
i don't think i know what script you're referring to.
The script that is called in the Datatables AJAX URL. That is the script making the query and returning the data. Sounds like the query needs to be modified to include the additional fields you want displayed in the child detail rows.
Kevin
That was it. Thanks so much.
Kevin, do you work for DataTables? I'm wondering if I owe a support charge.
You are welcome. Glad its working now.
No I don't.
No you don't
Kevin
Hi @StanR ,
A good way would be to check the network tab on the developer area of the browser, then you can see what the server is sending to the webclient. You could also try
JSON.stringify(d), that would show the contents of the object.What Kevin and I have been trying to understand is whether the object being returned, matches what you're you expect it to be. In your format function, you're accessing
d.explanationandd.groovydoc, so we'd expect to see those properties inside the objects being returned.Cheers,
Colin
I understand now. Thanks, guys.