Hi, I have a requirement from my business that we need to be able to aggregate specific content types across a large number of sites.

The kicker is that we need to split the results for each content type into different categories based on metadata that is controlled at site level.

I have the search result set up pretty ok so far. Filtered and split according to the metadata values on the items. So my question mostly pertains to how to get metadata assigned at site level and then propagated down onto all items.

My initial thought was to use a combination of lookups and calculated columns, and then just have a singleton metadata list to store the values. But a couple of gotchas deflated that idea: 1: You cannot lookup from a choice field. And 2: You cannot reference another list in a calculated column.

Any advice for how to achieve what my business desires?

Thanks in advance!

/Mikkel