I have an SP web with many reports (lists) in about 30 categories (libraries, soon to be databases), and the report lists have many custom columns, about 100 different ones across 150 reports.
I can add each column as a metadata property, run the indexes and collect the data, that part is behaving. I can search against the columns, so that's working.
The challenge is building an advanced search page. Each report has different custom columns against which I can search. I don't want to list all 100 potential properties in the advanced search dropdown, they'll never find anything.
The desire is to add the properties dynamically. Say report one has columns run date, ID and location, and report 2 has ID, location, start date and end date. I want to add the properties based on which report is pulled up, so they can search easily on each report's data.
The most obvious issue is that the advanced search web page is sealed, so I can't get to the engine, or at least not easily. The second is I'm not sure how to get to the XML that holds the property info, or if I have to try adding something later on in the process to add the objects to the generated dropdown.
Now if the solution is to build my own advanced search page, that's going to be a bear, so the backup question is can anyone recommend a good one that would give me the functionality I need?
I've got to assume I'm not the only one to see this as a need, the hope is that someone else has come up with a way to do it.