CAML Query to Display ListItems Based on current user permissions

Question

0.00/5 (No votes)

See more:

SharePoint2010

Hi,

I am facing a little problem in how to use CAML query in my code.

My scenario is as a user logs in the site check that particular user for his permissions on site and then display all the list items created by him or tasks created by him in a tabular form with a count of tasks for every month.

I am not able to understand how to integrate or use both the permission check and display list items together for the logged in user so that other users data is not visible to him.

Can any one guide me in this or direct me to a well structured code wherein i can get a reference.

I am novice in this and having a tough time in understanding how it all works.

Thanking in advance

Posted 8-Jul-13 3:01am

SourabhS123

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guptha Ch · Answer 1 · 2013-09-22T23:58:00

You have no need to worry about the permission of the user on the list to be queried because SharePoint will return the results based on the user permission on the list.

For returning only the items created by the current logged in user you can use the following CAML query

C#

"<Where>
 <Eq>
  <FieldRef Name="Author" LookupId="TRUE" />
  <Value Type="Integer">" + SPContext.Current.Web.CurrentUser.ID + @"</Value>
 </Eq>
</Where>"