I am currently using Spring and jquery datatable in my project. I want to implement a custom search in my application. I tried examples from this link. This example filters only the columns in the datatable. I have a column (say) Pencil and a user profiles. Now the scenario is many to many(one user can user many pencils or the same pencil can be used by many users). I am permitted only to show the user profile in the datatable but my filtering should also be done using the pencil name (ie) If I search for a pencil name all the users using the pencil should be listed in the datatable. I am able to fetch the data using spring from DB but I am not able to set in the data table. How can I achieve this?
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
--- Martin Fowler