Sorting Error for the Column with Data from Joined Table

poeziafree

Hello,

I am using the DataTables Editor Join functionality.

For the column that displays data from the joined table, the sorting cannot be performed.

Test Case: https://delivery.statiebi.com/datatable-editor/examples/extensions/searchBuilder.html

Column Name using the data from the joined table: Start Date

PHP Code:

`<?php

/*
* Example PHP implementation used for the index.html example
*/

// DataTables PHP library
include( "../lib/DataTables.php" );

// Alias Editor classes so they are easy to use
use
DataTables\Editor,
DataTables\Editor\Field,
DataTables\Editor\Format,
DataTables\Editor\Mjoin,
DataTables\Editor\Options,
DataTables\Editor\Upload,
DataTables\Editor\Validate,
DataTables\Editor\ValidateOptions;

// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'users' )
->fields(
Field::inst( 'users.id' ),
Field::inst( 'users.operator' ),
Field::inst( 'users.name' ),
Field::inst( 'users.surname' ),
Field::inst( 'users.active' ),
Field::inst( 'users.department' ),
Field::inst( 'users.pin' ),
Field::inst( 'users.email' ),
Field::inst( 'users.threshold' ),
Field::inst( 'users.date_last' )
)
->join(
Mjoin::inst( 'user_feedback' )
->link( 'user_feedback.operator', 'users.operator' )
->order( 'user_feedback.time asc' )
->where( 'user_feedback.time', 1633101482, '=')
->fields(
Field::inst( 'score' )
->set( false )
)
)
//->where( 'user_feedback.time', 1633101482, '=')
->debug(true)
->write(false)
->process( $_POST )
->json();
`

poeziafree

Hi @allan

Is there any mistake on my part?

Please, help me...

allan

Are you using server-side processing? Unfortunately, an Mjoin with server-side processing does not sort (indeed, I'm not actually sure what the correct implementation for this would be, since your be sorting first by the inner array in each row and then the contents of that array compared to other rows - does it use the first number, an average or something else).

With client-side processing it will sort, but it will be string based if you have non-numeric data visible.

Allan

allan

Sorry - I see you are using server-side processing. So yes, that is the issue.

You only have 8 records though - unless you are expecting it to grow to at least tens of thousands of rows, then just disable server-side processing.

Allan

komeyria55

Hi, i am also faced this issue. it is tough