2

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?

  • 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
1

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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy