SharePoint 2010：跨网站集的高效联合查询？
在 SharePoint 2010 中，我想在一个 SiteCollection 中创建一个列表，该列表从具有公共字段的其他几个 SiteCollections 查询数据：
这可能吗？如果可能的话 - 可以有效地完成吗？
当前提出的解决方案包括在我们想要查询的每个 SiteCollections 上设置 EventReceivers，并使用以下命令更新主列表（OverviewSiteCollection）：每次更新其中一个 SiteCollections 或添加数据时都会生成新数据。
有没有更好的方法来实现我们想要实现的目标？
In SharePoint 2010, I would like to create a list in one SiteCollection that queries data from several other SiteCollections that have common fields:
Is this possible, and if so - can it be done efficiently?
The current proposed solutions involves setting up EventReceivers on each of the SiteCollections that we want to query, and updating a master list (the OverviewSiteCollection) with the new data each time one of the SiteCollections is updated or has data added.
Is there a better way to achieve what we want to achieve??
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我大概就是这么做的。即使您位于同一个网站集中，我也想不出将项目聚合和复制到另一个列表中的方法。您可以通过事件接收器推送项目或通过作业定义拉取项目。
我唯一能想到的是新的分类字段和术语集。但这适用于基于文本的选择字段。我认为它不适用于您的示例中所示的多列项目。
That is probably how I would do it. Even if you were in the same site collection, I can't think of a way to aggregate and replicate items into another list. You could either push the items through an Event Receiver or pull the items through a Job Definition.
The only other thing I can think of are the new Taxonomy fields and Term Sets. But that is meant for text based choice fields. I don't think it would work for multi-column items as shown in your example.
不可能开箱即用，但您可以从闪电工具购买闪电导体 Web 部件。它的工作方式与内容查询 Web 部件类似，但它可以跨网站集工作。
它与 Sharepoint 2007 和 2010 兼容。
http://www.lightningtools.com /pages/lightning-conductor-web-part.aspx
http://www.lightningtools.com/blog/archive/2010/04/29/sharepoint-2010-and-the-lightning-conductor-web-part.aspx
至于它的效率，我不确定，因为我仅将其用于少量数据收集。
It's not possible out of the box, but you can buy the Lightning Conductor Web part from lightning tools. It works similarly to the Content Query Web Part, but it works across site collections.
It's compatible with Sharepoint 2007 and 2010.
http://www.lightningtools.com/pages/lightning-conductor-web-part.aspx
http://www.lightningtools.com/blog/archive/2010/04/29/sharepoint-2010-and-the-lightning-conductor-web-part.aspx
As for it's efficiency, I'm not sure, as I've only used it for small collections of data.
每当我考虑跨网站集滚动内容时，我都会考虑利用（如果可能的话）
1) 托管元数据服务（分类和共享内容类型）
2）搜索（利用搜索范围等）
3) 某种 Web 部件，用于在页面上显示数据。
效率是您关心的问题之一，搜索是您最好的选择！没有什么可以超越它的性能！
我遇到了一个很好的解决方案（扩展内容查询 Web 部件以跨网站集和外部源聚合数据），它可能会给您一些指导： http://www.msteched.com/2009/NorthAmerica/OFC405
但搜索有其局限性（结果的准确性取决于上次运行索引操作的时间）。如果这让您感到困扰，您可能最终会按照此处的建议手动迭代网站集列表：http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/d271da25-57f4-4f59-a34d-fd06bc4c8ce6
另一个答案中建议的闪电 Web 部件可能非常适合您。我建议对其进行评估（例如它内部的工作方式、权限、附加配置、效率、缓存、显示控制等）。
Whenever I think about rolling up content across Site Collections, I think about leveraging (if possible)
1) Managed Metadata Services (taxonomy and Shared Content types)
2) Search (leverage search scope etc)
3) Some kind of web part to surface the data on the pages.
And efficiency being one of your concerns, Search is your best bet! Nothing can beat its performance!
I have come across a good solution (Extending the Content Query Web Part to Aggregate Data Across Site Collections and External Sources) which might give you some directions: http://www.msteched.com/2009/NorthAmerica/OFC405
Search has its limitations though (the accuracy of the results depends on when the last index operation was run). If this bothers you, you may perhaps end up iterating the lists of your site collections manually as suggested here: http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/d271da25-57f4-4f59-a34d-fd06bc4c8ce6
The lightning web part as suggested in another answer could be a good fit for you. I would suggest to evaluate it (like how it does it internally, permissions, additional configuration, efficiency, caching, control over display etc).