使用 subjoin 过滤 Sharepoint Dataview
我有与 过滤/搜索加入的数据源数据视图 webpart 相同的问题大约六个月前。这应该是一个普遍的问题。
由于共享点在使用连接数据源时基本上组合了两个数据视图，因此我无法根据第二个数据视图（子级）进行过滤。我可以过滤父行或子行。但是子级无法阻止父级不显示特定行，而我在返回搜索结果时需要它。
我的父表是 sql，子表是 Sharepoint 列表。我的结果是，要么它根本不过滤，要么我收到 xslt 错误。有人可以帮助我吗？
I have the same question as Filter/search joined datasource dataview webpart which was asked about six months ago. This must be a common issue.
Since sharepoint basically combines two dataview's when using a joined datasource, I'm unable to filter based on the second dataview (the child). I can filter either rows of the parent or rows of the child. But the child cannot prevent the parent from not displaying particular rows, which I need it to when returning back search results.
My parent table is sql and the child is a Sharepoint list. My results have been that either it does not filter at all or I get an xslt error. Can someone help me?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我太难了。这很简单：
不过还有一个问题。我正在尝试使用
currentUser过滤器来过滤数据视图 Web 部件。我已经确认这适用于简单的 sql 查询。然而，它不适用于这个更复杂的 SQL 查询。有什么想法吗？注意：无需将参数与
CurrentUser过滤器一起使用。它会自动过滤页面。I was making it too hard. It was as simple as:
Another question though. I am trying to filter the dataview web part using the
currentUserfilter. I have confirmed that this works with simple sql queries. It is not working on this more complex SQL query, however. Any thoughts?Note: No need to use parameters with the
CurrentUserfilter. It automatically filters the page.