如何基于登录的用户ID过滤视图,用户ID是用逗号分隔的多用途值中具有用户ID的列之一 [英] How to filter view based on logged in User ID which is one of the columns which has user ID in comma seperated mutilple values
问题描述
如何根据登录的用户ID过滤视图,用户ID是用逗号分隔的多用途值中具有用户ID的列之一
How do I filter view based on logged in User ID which is one of the columns which has user ID in comma seperated mutilple values
>我无法使用[Me],并且列表已导入,并且有一列用户ID以逗号分隔
> I cannot use [Me] and the list is imported and has a column where the User ID is separated by commas
示例-列值是"EmployeeID1,EmployeeID2,EmployeeID3"
Example - Column Values is "EmployeeID1,EmployeeID2,EmployeeID3"
如果雇员ID在列表中,我想列出EmployeeID1的项目.
I want to list down the items for EmployeeID1 if his employee ID is in the list.
推荐答案
您好,Farhan Aliyar,
有一种方法.我们将在SharePoint设计器中编辑列表的CAML查询.
然后按照以下步骤操作:
1.在列表中,修改视图并在存储条件为包含aa"的用户ID的列上添加过滤器.
1. In the list, modify the view and add the filter on the column which stores user ID with condition "contains aa".
2.打开SharePoint Designer,单击列表和库,单击列表,单击在上一步中修改的视图,单击底部的代码,然后单击功能区中的高级模式".
3.找到"aa",然后将"aa"替换为< UserID/>".
4.保存更改.
毕竟,返回列表,它将显示该列包含当前用户ID的列表项.
最诚挚的问候
萨拉范
这篇关于如何基于登录的用户ID过滤视图,用户ID是用逗号分隔的多用途值中具有用户ID的列之一的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!