Add support for ColumnControl

[Th3Trig3rFac3]

A new, seemingly very useful, extension has been released. Might open a PR on the integration of it.

[swooningfish]

Agreed - Would be good return the ajax options for column control from this sample https://datatables.net/extensions/columncontrol/examples/searchList/ajaxOnly.html

The data elements already get returned. However would be good to have the columnControl and field valiues, plus the option when the FE filters on this it passes to the BE to process the new result set.

e.g.

{ "data": [ { "id": "1", "name": "Tiger Nixon", "position": "System Architect", "salary": "$320,800", "start_date": "2011-04-25", "office": "Edinburgh", "extn": "5421" }, { "id": "2", "name": "Garrett Winters", "position": "Accountant", "salary": "$170,750", "start_date": "2011-07-25", "office": "Tokyo", "extn": "8422" }, { "id": "3", "name": "Ashton Cox", "position": "Junior Technical Author", "salary": "$86,000", "start_date": "2009-01-12", "office": "San Francisco", "extn": "1562" }, { "id": "4", "name": "Cedric Kelly", "position": "Senior Javascript Developer", "salary": "$433,060", "start_date": "2012-03-29", "office": "Edinburgh", "extn": "6224" }, { "id": "5", "name": "Airi Satou", "position": "Accountant", "salary": "$162,700", "start_date": "2008-11-28", "office": "Tokyo", "extn": "5407" }, { "id": "6", "name": "Brielle Williamson", "position": "Integration Specialist", "salary": "$372,000", "start_date": "2012-12-02", "office": "New York", "extn": "4804" }, { "id": "7", "name": "Herrod Chandler", "position": "Sales Assistant", "salary": "$137,500", "start_date": "2012-08-06", "office": "San Francisco", "extn": "9608" }, { "id": "8", "name": "Rhona Davidson", "position": "Integration Specialist", "salary": "$327,900", "start_date": "2010-10-14", "office": "Tokyo", "extn": "6200" }, { "id": "9", "name": "Colleen Hurst", "position": "Javascript Developer", "salary": "$205,500", "start_date": "2009-09-15", "office": "San Francisco", "extn": "2360" }, { "id": "10", "name": "Sonya Frost", "position": "Software Engineer", "salary": "$103,600", "start_date": "2008-12-13", "office": "Edinburgh", "extn": "1667" }, { "id": "11", "name": "Jena Gaines", "position": "Office Manager", "salary": "$90,560", "start_date": "2008-12-19", "office": "London", "extn": "3814" }, { "id": "12", "name": "Quinn Flynn", "position": "Support Lead", "salary": "$342,000", "start_date": "2013-03-03", "office": "Edinburgh", "extn": "9497" }, { "id": "13", "name": "Charde Marshall", "position": "Regional Director", "salary": "$470,600", "start_date": "2008-10-16", "office": "San Francisco", "extn": "6741" }, { "id": "14", "name": "Haley Kennedy", "position": "Senior Marketing Designer", "salary": "$313,500", "start_date": "2012-12-18", "office": "London", "extn": "3597" }, { "id": "15", "name": "Tatyana Fitzpatrick", "position": "Regional Director", "salary": "$385,750", "start_date": "2010-03-17", "office": "London", "extn": "1965" }, { "id": "16", "name": "Michael Silva", "position": "Marketing Designer", "salary": "$198,500", "start_date": "2012-11-27", "office": "London", "extn": "1581" } ], "columnControl": { "position": [ "Accountant", "Chief Executive Officer (CEO)", "Chief Financial Officer (CFO)", "Chief Marketing Officer (CMO)", "Chief Operating Officer (COO)", "Customer Support", "Data Coordinator", "Developer", "Development Lead", "Director", "Financial Controller", "Integration Specialist", "Javascript Developer", "Junior Javascript Developer", "Junior Technical Author", "Marketing Designer", "Office Manager", "Personnel Lead", "Post-Sales support", "Pre-Sales Support", "Regional Director", "Regional Marketing", "Sales Assistant", "Secretary", "Senior Javascript Developer", "Senior Marketing Designer", "Software Engineer", "Support Engineer", "Support Lead", "System Architect", "Systems Administrator", "Team Leader", "Technical Author" ], "office": [ { "label": "Berlin", "value": "Berlin" }, { "label": "Edinburgh", "value": "Edinburgh" }, { "label": "London", "value": "London" }, { "label": "Madrid", "value": "Madrid" }, { "label": "New York", "value": "New York" }, { "label": "Paris", "value": "Paris" }, { "label": "Perth", "value": "Perth" }, { "label": "San Francisco", "value": "San Francisco" }, { "label": "Singapore", "value": "Singapore" }, { "label": "Sydney", "value": "Sydney" }, { "label": "Tokyo", "value": "Tokyo" } ] } }

[swooningfish]

May need to wait till version 1.1 of ColumnControl is available as the filters are not being passed to the ajax calls yet
https://datatables.net/extensions/columncontrol/server-side

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.