Filter SharePoint Document List : current user
I am trying to use the [ME] construct to filter a view of documents. The filter needs to apply to a multi-value field using the "contains" parameter. When I attempt this, I get: <!-- #RENDER FAILED --> Does anyone know how I might overcome this???
April 13th, 2010 2:18am

Did you try using a Filter Web part? I believe you can use the current user filter webpart to pull in the current user's id and use it to filter your view. ChrisChris Givens CEO, Architecting Connected Systems Blog Twitter
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2010 3:54am

Chris, I have tried using the "current user" Filter Web part - but I found no way to associate the "contains" parameter with the field I am trying to filter on; the default appears to be "equal to" with no alternative way to designate a relationship? I am able to use the contains statement within the standard view creation screen to filter on a specific name included in the multi-value field but the [ME] construct produces the render failed response. Using the [ME] construct with a non-multi-value field does not return the render failed error but it also does not return the expected document list.
April 13th, 2010 4:52am

Hmm, why do you need to use contains? Is it a column with of lots of individuals? I suppose since the filter web part won't work, you can try to use the DataView web part and implement a contains filter based on current user. ChrisChris Givens CEO, Architecting Connected Systems Blog Twitter
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2010 5:46am

Thanks for responding Chris. I have a multi-value field called Recipients; within that field one or numerous "recipients" (SPUSER name) are listed; I want to create a MY VIEW filter that will display only those documents where the current user's name is included in the Recipients field.
April 17th, 2010 9:20pm

What type of field is Recipients? Is it a People Picker or something else?SharePoint Architect || Microsoft MVP || My Blog
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2010 4:50am

Recipients is a multi-value choice field. As a multi-vlaue field it is by default a text field, consequently using the [ME] construct produces a "render failed"; and for experimentation when I try to use the "contains" parameter on a people/group field such as "modified by" it is disallowed with the statement that the field type does not allow "contains". So, even if I could make the field a "person" type (and I don't know how to do that) it would not allow me to use contains and I doubt that it would allow me to make it a multi-value field.
April 18th, 2010 10:50pm

Yeah, that's what I figured. [ME] only works when compared against people type fields anyway. The value it's looking for is domain name, even though what we see is the real name. What sort of values are you in your multi-choice field? The key thing to realize that the [ME] functionality is not just comparing arbitrary text - it's actually comparing identities. Text choices in a choice column are not identities. You make a "person" type field the same way you make any new column - you just choose People Picker instead of Choice. They are just two of the available column types. Also, when creating the People Picker field, you can choose to allow single or multiple values plus people only or people and groups. This is the type of field that [ME] is intended to be leveraged against, but as you saw, it doesn't work out of the box with multi-value fields - the "contains" operand is not allowed thusly.SharePoint Architect || Microsoft MVP || My Blog
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2010 11:30pm

Hey, I am having the same issue. Did you find any answer for your problem? If yes would you mind letting us know how you handled it? THanks in advance. Chamy07
June 18th, 2010 8:20pm

Chamy, I gave the answer, and it was marked.SharePoint Architect || Microsoft MVP || My Blog
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2010 8:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics