Join tables - one-to-many join with serverSide: true - Not working

Join tables - one-to-many join with serverSide: true - Not working

khellendros74khellendros74 Posts: 6Questions: 3Answers: 0

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

  • allanallan Posts: 65,162Questions: 1Answers: 10,796 Site admin
    Answer ✓

    ordering, searching are not working with the joined table field from permission

    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

  • khellendros74khellendros74 Posts: 6Questions: 3Answers: 0

    as always thanks for your quick answers :)

Sign In or Register to comment.