Stay in the page than contains the record I modify

jgcaudet

Hi Allan.
When I modify a record via Editor and press Update, always send my dataTable to the first page. How can I stay in the page that include my record ?
I looked for in forums but I can´t find a solution.

Thanks

allan

This is caused by the call `dt.fnDraw();` on line 2855 in the Editor library. If you modify that to be `dt.fnDraw( false );` that will keep the current paging.

I'm going to add this ability as a feature in the next release of Editor, which will be building upon the DataTables 1.10 API, which has much better control of holding the page static.

Regards,
Allan

jgcaudet

It could be the line 2837 in Datatables 1.9.4 ?

allan

Actually, my apologises - I was looking at the delete draw there. The code you are looking for is `dt.fnUpdate( setData, that.s.editRow );` in Editor (line 2834 in Editor 1.2.2). You could change it to: `dt.fnUpdate( setData, that.s.editRow, undefined, false );` . However, be aware that your new data won't be sorted or filtered until you do a full redraw.

Allan

jgcaudet

Hi
I use dataTables.editor.js version 1.2.3.
The line you mention is 2856, but with this change it doesn,t works.
With the first modification : dt.fnDraw( false ) in line 2837

if ( dt.fnSettings().oFeatures.bServerSide ) {
// Regardless of if it was a new row, an update or an delete, with
// SSP we draw the table to refresh the content
dt.fnDraw(false);
}

But I am not secure enough if this is correct.

jgcaudet

I mean that with dt.fnDraw(false) in line 2837 works. I dont know if it has collateral efects.

allan

Are you using server-side processing? The block you indicate above will only execute if you are.

It sounds like you might actually be best off waiting for the next release which will have this ability built in. Although I am surprised that the change to fnUpdate didn't work.

Are you able to link me to the page so I can take a look at what is happening?

Allan

jgcaudet

I send you the link by mail. It´s not secure enough. Sorry.

AKM3

Hello Allan,
your code: dt.fnUpdate( setData, that.s.editRow, undefined, false );

Works and keeps the current page when you Edit an existing row.

For my particular project, where I just need to show last page, I added this line:
[code]
if ( dt.fnSettings().oFeatures.bServerSide ) {
dt.fnDraw();
}
else if ( that.s.action === "create" ) {
// New row was created to add it to the DT
if ( that.s.idSrc === null ) {
setData.DT_RowId = json.id;
}
else {
setFn = dt.oApi._fnSetObjectDataFn( that.s.idSrc );
setFn( setData, json.id );
}
that._callbackFire( 'onPreCreate', [json, setData] );
dt.fnAddData( setData );
//Added go to last page after inserting
dt.fnPageChange( 'last' );
that._callbackFire( ['onCreate', 'onPostCreate'], [json, setData] );
}
[/code]

However I would like to keep this changes away of your editor code. Is there any way to put an external "on create" function that triggers on a successful editor insert ?
Thank you very much for all the guidance

allan

> Is there any way to put an external "on create" function that triggers on a successful editor insert ?

Yes indeed - on the next line of code you'll see the onCreate and onPostCreate events that Editor fires. So you could do:

[code]
editor.on( 'onCreate', function () {
table.fnPageChange( 'last' );
} );
[/code]

i.e. listen for the event and act upon it when it occurs.

Allan