JoinArray (Sort, Search) feature not work when set serverside:true

JoinArray (Sort, Search) feature not work when set serverside:true

etomixetomix Posts: 3Questions: 1Answers: 0

Description of problem:
I use this Example Link: https://editor.datatables.net/examples/advanced/joinArray and I just set serverside:true & processing:true

After that Sorting & Search feature is not working I got this Error
Unknown field: permission (index 3):

$('#example').DataTable( {
    dom: "Bfrtip",
    ajax: {
        url: "/api/joinArray",
        type: 'POST'
    },
    serverSide: true,   // added serverSide
    processing: true, // added Processing
    columns: [
        { data: "users.first_name" },
        { data: "users.last_name" },
        { data: "users.phone" },
        { data: "permission", render: "[, ].name" }
    ],
    select: true,
    buttons: [
        { extend: "create", editor: editor },
        { extend: "edit",   editor: editor },
        { extend: "remove", editor: editor }
    ]
} );

Can anyone please help me out?
Thanks in advance

Answers

  • tangerinetangerine Posts: 3,365Questions: 39Answers: 395

    Are you using the server script from the example?

  • etomixetomix Posts: 3Questions: 1Answers: 0

    Yes I am using server script from example

  • etomixetomix Posts: 3Questions: 1Answers: 0

    Yes

  • colincolin Posts: 15,240Questions: 1Answers: 2,599

    That serverSide script isn't setup to use server-side processing - you would need to either customise it to be respond appropriately for SSP, or modify the SSP scripts to do what you want,

    Colin

This discussion has been closed.