How to filter lists so that display only particular records to particular user in sharepoint 2010

Pertanyaan How to filter lists so that display only particular records to particular user in sharepoint 2010

  • 19 Maret 2012 3:47
     
     
    I have a list containing user and other data. I need to display say user1 is accessing that and user1 can see only user1's data (these records aren't created by them) and user2 can see their data also no user can see other users data. how to do that. I am a newbie please provide me detailed solution. Thanks in advance

Semua Balasan

  • 19 Maret 2012 3:55
     
     
  • 19 Maret 2012 4:59
     
     
    Dealing with Item level permission is a royal pain in SharePoint. However, let's try to keep these groups on topic, so kindly move this to the SharePoint 2010 area, not the Pre-2010 where you posted.

    Imagine what we could be...if we could just imagine. | Daniel A. Galant | Sr. SharePoint Solutions Architect EPC Group.net

  • 19 Maret 2012 5:35
     
     

    Hi prakashranganathan,

    That can be done easily from Modify View of the Particular List.

    Step 1) Go to Modify View of the List that you want to filter as shown below.

    Step 2) Go to the Filter and you can add any one of the filter as shown below.

    By adding the filter equal to [Me] only the records that are created or assigned to particular user is visible on user's login.

    Hope that helps!!!


    Thanks, Suraj Bangera | http://linkd.in/xXf8nk

  • 20 Maret 2012 2:48
    Moderator
     
     

    "user1 can see only user1's data (these records aren't created by them) and user2 can see their data also no user can see other users data."

    Then what's your criteria for setting permission? set permission for item one by one? or use folders to organize items and set permission on folder level?

  • 22 Maret 2012 3:39
     
     

    Guys Thanks for your  reply Lets make it clear, consider I am the admin i am creating a list like this with the following data (all records are created by myself and not by the user)

    User count

    user1 65

    user2 77

    user3 55

    Now if user 1 access the sharepoint url I want him to see only his record that is in this case "user1  65"  and similarly for other user. Thanks

  • 22 Maret 2012 4:14
     
     

    filter the List values using  "User" field  is equal to [Me]

    http://sharefort.blogspot.in/2008/03/using-me-filter-in-sharepoint.html


    MCTS,MCPD Sharepoint 2010. My Blog- http://sharepoint-journey.com
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful



  • 22 Maret 2012 6:26
     
     

    "filter the List values using  "User"  field  is equal to [Me]"

    If I do as you said I am getting error message as 

    Filter value is not a valid text string

  • 22 Maret 2012 6:38
     
     

    "Here's what I usually do in order to accomplish this.  Ultimately you'll need to have 2 different fields.  There's the one you already have, with username stored in it.  Then you'll need an additional field as a "person" column type.  Call it "TargetPerson" or something.

    Create a sharepoint designer workflow that runs each time an item is created or changed.  One action:

    Set FIELD to VALUE.

    The first FIELD is "TargetPerson", the VALUE is your "TargetUser" field. 

    Once this is done, then the person value is stored in the person field.  This is the field that you can filter by "TargetPerson" is equal to [Me]"

    check the below thread:

    http://social.msdn.microsoft.com/Forums/en/sharepointcustomization/thread/13784bb8-5ec3-4cd0-b995-79b44d9b1438



    MCTS,MCPD Sharepoint 2010. My Blog- http://sharepoint-journey.com
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful


  • 22 Maret 2012 6:54
    Moderator
     
     
    so, you are not using Person and Group type of field for user?
  • 28 Maret 2012 3:37
     
     


    @devendra.sv thanks, but I dont understand I had created a list with two columns like Userid and ID number now how to create a workspace and add another column targetperson