Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user.

I tried doing this with CAML in SharePoint Designer but was not able to retrieve a value from the User Information List based upon the current user. (I was able to filter by the user group though.)

I found a tool that did a lookup on this list, but it required WSS 3.0 and I am running SharePoint Foundation.

Can I do a lookup on certain field in the User Information List for the logged in user and store that value in a variable in Sharepoint Designer? Will I need to use VS?

share|improve this question
    
SharePoint 2010 has 'binding redirects' that make WSS 3.0/MOSS 2007 code think it is running on that older platform. Have you tried ignoring the tool's requirements and running it anyway? It may work. –  Alex Angas Jul 5 '10 at 4:43
    
Hi Alex, It wont install unless I have WSS 3.0. Thank you for all your previous help today. Richard –  Anonymous Jul 5 '10 at 17:29
add comment

1 Answer

up vote 1 down vote accepted

Can you use javascript and the web services to get this info? That is how I get data from the user info list for the current user. There is also a jQuery library that makes it even easier here

share|improve this answer
    
Hi spevilgenius. I tried this but had problems with ajax. Can I do what you suggested while running Sharepoint foundation? I tried to follow this example: midnightprogrammer.net/post/… Thanks again. Richard –  Anonymous Jul 7 '10 at 21:53
    
I personally have not used foundation yet, but I do know that the SPServices library works in it. There is a lot of information at the spservices.codeplex.com site. –  spevilgenius Jul 8 '10 at 0:05
    
Hi spevilgenius. I am learning about client side classes from here: msdn.microsoft.com/en-us/library/ee857094.aspx. Do you know how to get lookup fields to show their id value? Thank you. Richard –  Anonymous Jul 8 '10 at 4:40
    
Lookup values are stored in a somewhat strange format: id;#value If you are getting this value in javascript, you can get the value as a string and then split that string on the ; character. The resulting array will have two parts like array[0] = id and array[1] = #value and you could also split that last one if you want the value as well. Hopefully this gets you going! –  spevilgenius Jul 8 '10 at 17:11
    
Thank you spevilgenius. –  Anonymous Jul 9 '10 at 16:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.