如何基于登录的用户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屋！