SharePoint 筛选列仅允许项目使用一次
我有一个用于变更管理的 WSS 3.0 站点。它包含三个主要列表——错误列表、增强列表和发布列表。版本列表有两个查找列，提供该特定版本中包含的错误和增强功能的列表。
我正在尝试找出如何过滤错误和增强列表以仅包含尚未包含在其他版本中的项目。我见过的有关过滤查找的所有文档和示例都处理列表本身的查询。对于我的情况，如果这是一个 SQL 查询，我需要使用 LEFT JOIN 来生成列表。
I have a WSS 3.0 site that I use for change management. There are three primary lists on it -- a bug list, an enhancement list, and a release list. The release list has two lookup columns that provide a list of bugs and enhancements that are included in that particular release.
I am trying to figure out how to filter the bug and enhancement list to include only items that have not already been included in another release. All the docs and examples I have seen regarding filtered lookups deal with a query on the list itself. For my situation, and if this was a SQL query, I would need to use a LEFT JOIN to generate the list.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
要使用 SharePoint 列表（例如关系表），您应该尝试 SLAM （SharePoint 列表关联管理器），即这正是您在这种情况下所需要的。
设置关系后，您将拥有一个数据库，可用于查询并确定值是否已在自定义筛选查找字段中使用。
To use SharePoint lists something like relational tables, you should try out SLAM (SharePoint list association manager), that is just what you need for this situation.
After you've set up your relations, you will then have a database you can use to query and determine if value has been used or not within your custom filtered lookup field.