SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I want to implement search functionality depending on the column.
Suppose I have a column name "Country" then on the basis of the country column different countries are available in drop-down and click on one country will filter the SharePoint list.
But the major issue is that I have 100 columns and when user type any column name in input field, it will populate all the drop-down corresponding to that column in the drop-down field and depending on that filter will be applied on the list.
I think a cool way to handle this would be to use dataTables JS-library which queries your list's REST API and provides the relevant filter/search fields. Because someone else has thought about this earlier as well, there's this many times referenced article Who Needs a Data View Web Part? SharePoint REST and DataTables (YouTube-version: https://www.youtube.com/watch?v=f4S3qo3kWz8) describing what should be done, step-by-step. You might also want to have a look at questions tagged as datatable as most of them attempt to achieve a similar requirement.
To get started, add the required JS files (jQuery, dataTables) to your SharePoint's shared library (Site Assets would be the best). Then create your HTML for the search fields and for the search-button. Finally implement the JS function which would be fired with the search-button. The JS function shall do a REST call to your SP list's REST API in ajax and wrap the results into a JSON format. Finally the function shall lay the retrieved data into the dataTables according to its own syntax.
