trying to work this out...I have Project Sites (Team Sites) that have a site column added to the Site Pages Library. You edit the properties of the Home Page and select a client name that the project relates to (Lookup to a Client list). There for The meta data entered on the home page will then be part of the sts_site/sts_web item which is indexed.
I need to develop a "Search Centre" whereby I can get all the Documents based on the Client Property of the sites. For example show me all the Project Documents for Client XXX, keeping in mind that Client XXX may have a number of different project sites.
Shared Columns
and to have a well planned site content type & site column usage for the least effortless maintenance. To give an example for approach, please specify your planned structure.