Join tables - one-to-many join (datatable sorting Unknown FIELD)

Join tables - one-to-many join (datatable sorting Unknown FIELD)

Gerald.RagerGerald.Rager Posts: 19Questions: 3Answers: 0

Hello

i used the https://editor.datatables.net/examples/advanced/joinArray.html example

everthing works fine i got the data in the table and can edit the data

but

if i klick on the header for the datafield for sorting i became the failure that the Field ist Unknown

please help me

thanks

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,523Questions: 1Answers: 10,473 Site admin
    Answer ✓

    The Editor libraries do not currently support sorting or filtering on the "many" columns in a one-to-many join when using server-side processing. The reason for this is that the queries are actually individual queries against the database. If you need sorting on those columns you would need to use client-side processing at this time.

    Regards,
    Allan

This discussion has been closed.