Single Editor for two different DataTables on same page

Loren Maxwell

I have two DataTables on the same page that query the same MySQL database table on the backend (they are just filtered differently, such as "Employees in North America" and "Employees in Europe").

Is it possible to use the same Editor for both DataTables?

allan

Currently no - sorry. There can be multiple Editor instances for a single DataTable, but currently not multiple tables for a single Editor instance. You'd need to make two Editor instances.

Allan

Loren Maxwell

Thanks, @allan.

Based on that, here's my solution in case anyone else is looking for something similar:

// Specify everything except the table
const editor_config = {
   blah blah blah
}

// Create an instance for each table
new DataTable.Editor(
    $.extend(
        editor_config,
        {table: '#employees-from-north-america'}
    )
)
new DataTable.Editor(
    $.extend(
        editor_config,
        {table: '#employees-from-europe'}
    )
)

This allows me to update editor_config only once and the changes are reflected in both editor instances.

allan

Perfect!

Thanks for sharing that with us.

Allan