All, before I delve into the deep end trying to solve a list view query/search issue I seek guidance on the best practice method or reference articles that will help me resolve the dilemma I define below.
I have an Infopath form library (defined as a content type) in which the majority of form metadata is defined as columns items in the form library, approximately 25 columns. The information architecture approach ( and to mitigate the 2000 limit) will be to archive forms off to sub folders which are to be searchable. The user will like to dynamically query/filter all rolled-up lists on only a subset of columns (approx 7 of the 25) - similar to a traditional search/results type of interface. What is the best way to facilitate this in SharePoint ? I have installed the bamboo list roll up web part and created list views but neither seem to allow me to dynamically set the filter critieria on only a subset of columns. Some options I thought of include: 1) Data View WebPart (I believe you can associated multiple datasources (ie libraries) as the source data reference ) 2) Content Query Web Part 3) 3rd part controls - ie Bamboo list rollup or others 4) Connected WebParts to (can you have multiple filter web parts connected to a list view?) 5) Reporting Services report - how do you rollup the multiple datasources 6) Asp.Net control 7) SharePoint Search - I have excluded this list from being searched since am treating the form as a LOB application The premise of the design is to empower a subset of Power Business users to maintain the system so the intent is to keep the solution and underlying datasources non-complex. The user would also like to output to excel on the list view results also Cheers Matt
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
