How can I filter a Sharepoint 2007 libarry list based on current user login?

1
votes

I would like to know how I can filter a SharePoint library list based on current user login.

Suppose I have created the followings: 1) A SharePoint form library containing bunch of uploaded InfoPath form data. 2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.

I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.

I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK. Apparently [Me] returns a Person/Group data type and the filter cannot compare its value to that of "TargetUser".

I tried using other text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me]. The filter accepted the parameter without any error but the resulting fitlered list does not display any items at all.

I have googled this subject but I have not found any solution.

It would be greatly appreciated if anyone can help me to create a functional filtered list. And FYI, my SharePoint 2007 installation is just WSS 3.0 + Form Server. I do not have MOSS 2007 (so no MOSS 2007 web parts or web services).

Thank you.

Jason

2
sharepointsharepoint-2007

2 Answers

1
votes

Is there any reason your TargetUser field is a text field instead of a People or Group field? The [Me] identifier can be used to filter list items based on a People or Group column, but not on text fields.

1
votes

Well. It looks like no one here has the answer. Nevertheless, another user on Technet forum has a very good solution. See this link for more information