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 May 23 '14 at 22:52

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 May 25 '14 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 May 25 '14 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 May 25 '14 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 May 29 '14 at 21:17

Your Answer

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

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