[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

CAML Query Syntax?

Asked by Jovix in MS SharePoint

Tags: CAML, Sharepoint

Hello everyone, hope you can help me figure this out.

I'm new at all of this and I am trying to use a CAML query in a Contect Editor Web Part. The Web Part will be placed on the site collection's homepage, and the my CAML Query needs to pull from a List that is in one of my subsites.  Furthermore I need to only query the items in the list that were created by the current user.

I'm using U2U CAML Query Builder but I don't know what I'm looking at:
1. I don't know how to point the CAML Query to the List in my Sub Site.
2. I don't know how to tell the Query to pull only items for the Current User.

There might be an easier way of doing this but I would really like to learn how to do this stuff using CAML.

Below is my current CAML Query generated by the U2U Query Builder:
1:
2:
3:
4:
5:
6:
7:
8:
<Query>
   <Where>
      <Eq>
         <FieldRef Name='Author' />
         <Value Type='User'>User</Value>
      </Eq>
   </Where>
</Query>
[+][-]06/03/09 01:00 PM, ID: 24540612Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06/03/09 01:08 PM, ID: 24540708Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06/03/09 01:12 PM, ID: 24540758Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06/03/09 01:29 PM, ID: 24540985Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06/03/09 01:57 PM, ID: 24541276Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06/05/09 08:12 AM, ID: 24557235Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06/05/09 09:11 AM, ID: 24557812Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06/05/09 09:20 AM, ID: 24557879Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06/05/09 12:16 PM, ID: 24559389Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06/05/09 01:23 PM, ID: 24559877Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06/06/09 07:43 AM, ID: 24563156Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625