How to change the default order in a particular search pane ?

MelodyNelson

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

Hi,

I'm using SearchPanes like this :

searchPanes: {
     columns: [15, 1, 2, 3, 13]
}

The column 15 of my table contains years and I would like to change the default order only in this pane. I want a descending order by default for the years.

I didn't find an option to do it (maybe I didn't see it...)

Thanks for your help

kthorngren

I believe you will want to use columns.searchPanes.dtOpts to set the order option the column 15 pane.

Kevin

MelodyNelson

Thanks Kevin.
I'm not sure I'm doing the right thing.
I've tried the following code but all the panes disappear, only the links collapse, show and clear the panes are visible on the page.

searchPanes: {
            columns: [15, 1, 2, 3, 13],
            dtOpts: {
                order: [15, 'desc']
            }
        }

colin

That's close! Here's an example, take a look at the age column, that's similar to what you want. The SearchPanes only have two columns, so you're referring to column 0 - the column with the data.

    columnDefs: [{
      targets: 3,
      searchPanes: {
        dtOpts: {
          order: [0, 'desc']
        }
      }
    }]

Colin

MelodyNelson

Thanks a lot Colin.

It's nice that I can put it in columnDefs, now it's ok with all these defs :

        columnDefs: [
            { visible: false, targets: [1, 15] },
            { render: DataTable.render.number(' ', null, 0, null, ' €'), targets : [9, 10, 12] },
            { searchPanes: { dtOpts: { order: [0, 'desc'] }}, targets: 15}
        ]