I am looking for some ideas/experiences people have had working with the 5k view throttling .
Outcome I am trying to achieve: users can search for documents in a particular document library by filling in a form. Form will have drop down fields containing the available filter/metadata options for this Library. The idea is to have a form to create a query/view. This form will have drop down boxes. The value for the drop down boxes will be obtained dynamically from the library - unique values from key columns.
User would select values in the drop down boxes, press search, then a view of the library will be displayed, filtered based on the values selected in the form.
What happens after the form is filled out and a user selects "Search" is where i am unsure; If the list had <5k items, I could build a URL that filters the default (All Documents View) e.g. FilterField1=DocumentType&FilterValue1=Contract&FilterField2=Status&FilterValue2=Pending
I could dynamically create CAML query based on values from the form. Then present the results in a custom page - that would exactly replicates a OOTB library - column filtering, etc.?
What are my options?