Join tables - one-to-many join with serverSide: true - Not working
Join tables - one-to-many join with serverSide: true - Not working
khellendros74
Posts: 6Questions: 3Answers: 0
in Bug reports
Link to test case: https://editor.datatables.net/examples/advanced/joinArray.html
Debugger code (debug.datatables.net): opoyod
Error messages shown: DataTables warning: table id=messageBoard - Unknown field: permission (index 3)
Description of problem: ok, my debug is from my code, but it 100% same code from your example
if i m activating serverSide: true on datatable, with an server Mjoin, ordering, searching are not working with the joined table field from permission
This question has an accepted answers - jump to answer
Answers
That is expected I'm afraid. Mjoin does not currently support ordering and search when using server-side processing. The reason for that is that the Mjoin is a separate SQL query - the ordering and search have already been done on the main query, and the "many" elements are then obtained using a second query.
Allan
as always thanks for your quick answers