Please help if there is a solution out of box in SharePoint 2010, which helps filter datasheet view on currentusergroup.

Through sharepoint designer, it is doable to change CAML

    <FieldRef Name="AssignedTo"/><Value Type="Integer">
    <UserID Type="Integer"/></Value>
    <Membership Type="CurrentUserGroups">
    <FieldRef Name="AssignedTo"/>


However this is not out of the box, and since SPD is disabled in moss 2010, it cannot be used.

I am asking if there is out of the box solution where you can set code in the browser?

  • 1
    Please update your question with a full description of the problem and what you have already attempted. The link you provided is good extra info, but if the link breaks in future, your question will be rendered meaningless.
    – Phil Greer
    Commented May 23, 2014 at 22:52

1 Answer 1


Use JQuery with SPServices(spservices.codeplex.com), it uses a CAML query to return results. Your script can be added to the page using a text document uploaded to any library and then called via the content editor web part.

  • Thanks Aboba, I would like to try it! If possible, could you please help with a concrete example with datasheet list view?
    – stoneclub
    Commented May 25, 2014 at 9:26
  • It's not going to be using datasheet list view. SPServices is going to return the results as an xml object which you will then need to modify to whatever you want to output on the screen.
    – Aboba
    Commented May 25, 2014 at 17:56
  • if you can use SPD, the trick is to change WHERE clause in the <ListViewXml...> tag. Is this not possible on the fly as well? Datasheet is prefered as users could then mass change items in the filtered list if necessary.
    – stoneclub
    Commented May 25, 2014 at 18:05
  • 1
    Aboba, thanks, I read some documentation and could find out how it works. SPServices is a great tool, it did the trick.
    – stoneclub
    Commented May 29, 2014 at 21:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.