Disable SearchBuilder for Column

washuit-iamm

  {
    title: "Product Tags",
    data: "Product",
    render: function (products) {
      return products.reduce(function (acc, cur) {
        return acc + `<span class="badge text-bg-light mx-1">${cur.Name}</span>`;
      }, "");
    },
    visible: true,
    sortable: false,
    searchable: false, // This does not disable searchBuilder!!!
  },

Looking for something like searchBuilderEnabled: false

kthorngren

See if searchBuilder.columns does what you want.

Kevin

washuit-iamm

@kthorngren

That is a white-list and not a black-list right?

I have over 100 columns, that would be very ugly for me to have to remember yet another place to list my columns.

If it automatically opts-in to my columns, why cant I opt-out?

washuit-iamm

@kthorngren

Went with this route, don't love it but its terse enough...

columns: function (idx, data, node) {
    const column = table.column(idx);

    if (column.title().toLowerCase() ===
        "product tags") {
            return false;
    }

    return true;
}

kthorngren

The searchBuilder.columns states this:

This accepts all of the options of column-selector such as class name selector, jQuery pseudo selects and column index selectors.

You could assign a className to the columns you want to opt-out of SearchBuilder then use the jQuery :not() selector. For example:
https://live.datatables.net/fabaxeni/1/edit

Kevin