Where can I input the where clause?

misteam

function update_data ( $db, $id) {
$db->update( 'transactions', array(
'counter' => $id
) );
}

->on( 'postCreate', function ( $editor, $id, $row ) {
update_data ( $editor->db(),$id);
})

rf1234

https://editor.datatables.net/manual/php/conditions

Some more complex example here: https://datatables.net/forums/discussion/comment/162022#Comment_162022