syntax on server side
syntax on server side
classic12
Posts: 228Questions: 60Answers: 4
in DataTables
Hi I have the following working okay
Editor::inst( $db, 'anims' , 'animID')
->fields(
Field::inst( 'anims.animID' ),
Field::inst( 'anims.title' ),
Field::inst( 'anims.url' ),
Field::inst( 'anims.status' ),
Field::inst( 'anims.type' ),
Field::inst( 'anims.thumbnail' )
)
->where('anims.status', 'active', '=')
->where( 'anims.type', 'iframe', '=' )
//->order('anims.animID','ASC')
->process( $_POST )
->json();
How I do
- on there where make the 2 OR
- order by anims.animID ASC or DESC
Cheers
Steve Warby
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
https://editor.datatables.net/manual/php/conditions
from the docs:
order by isn't working with Editor, only for options instances. You are supposed to order data on the client side. If that isn't suitable for you you can use a view with order by. In that case it should be an updatable view though.
Thanks for the info