I have a requirement where list items are stored in multiple folders. Now users should be able to apply the filters as they would do if they do not have folders.
It looks like I have a build a custom webpart or application page that would allow them to set the filter and display the items on a button click.
How would I approach this problem? Probably I should have some controls like Textbox and Dropdown controls, use the CAML query to get the result and display it on the Datatable?