Tag Archives: CAML

CAML Query – Show element not assigned to me or my groups

Hello everyone, Some time ago, I made a summary post on « Filter on current user and current user groups » This query uses the “membership” parameter to recover the current user groups. However, some time ago, a request was made on … Continue reading

Posted in SharePoint 2007, SharePoint 2010, SharePoint 2013 | Tagged , | 1 Comment

CAML Query – Membership attribute

Hello everyone, Today I’ll talk about a CAML query attribute, the “membership” attribute. This attribute allows especially to query the groups the current user! If we look at the msdn documentation, we see that there are 5 different settings possible. … Continue reading

Posted in SharePoint 2010 | Tagged , | 3 Comments

Query only approuved files

Hello everyone, Today I will talk about a little trick that a friend gave me recently. Having used to work with SPQuery, I was already familiar with the attribute needed to query all the file within list’s folder: SPQuery.ViewAttributes = … Continue reading

Posted in SharePoint 2010 | Tagged , | 2 Comments

Tool for CAML Query

Hello everyone, For those who do not know, there is a tool to generate your CAML queries. This utility is the work of Karine Bosch and Andy Van Steenbergen For SharePoint 2003 and 2007 we had the CAML Builder tool, you can … Continue reading

Posted in SharePoint 2007, SharePoint 2010 | Tagged , , | 7 Comments

Filter on current user with CAML Query.

Hi everybody, Today I will give you a little trick with CAML Query: how to retrieve the current user. Logic suggests that we write a query like this: <Eq> <FieldRef Name=’AssignedTo’ /> <value Type=’User’> [Me]</ Value> </ Eq>  But then, it does not work … The proper way to retrieve the current user is to change our query like this. <Eq><FieldRef Name=’AssignedTo’ /><Value Type=’Integer’><UserID Type=’Integer’/></Value></Eq> And that … Continue reading

Posted in SharePoint 2007, SharePoint 2010 | Tagged , | 4 Comments