Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. SharePoint
  4. Caml Query Help

Caml Query Help

Scheduled Pinned Locked Moved SharePoint
helpsharepointdatabase
2 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    sheldons
    wrote on last edited by
    #1

    HEEEEEEELP! I am executing this as an async query with the the following caml below. I keep getting an error returned.

    <View>
    <FieldRef Name='myID' />
    <FieldRef Name='ContentType' />
    <FieldRef Name='DocName' />
    <FieldRef Name='myFirstName' />
    <FieldRef Name='myLastName' />
    <Query>
    <Where>
    <And>
    <In>
    <FieldRef Name='ContentType' />
    <Values>
    <Value Type='Text'>CT1</Value>
    <Value Type='Text'>CT2</Value>
    <Value Type='Text'>CT3</Value>
    <Value Type='Text'>CT3</Value>
    </Values>
    </In>
    <Eq>
    <FieldRef Name='myID' />
    <Value Type='Text'>{0}</Value>
    </Eq>
    <IsNull>
    <FieldRef Name='AnotherID'></FieldRef>
    </IsNull>
    </And>
    </Where>
    </Query>
    </View>

    Below is the message and exception that I am getting back. Message: "Cannot complete this action.\n\nPlease try again." Exception: {Microsoft.SharePoint.Client.ServerException: Cannot complete this action. Please try again. at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse(HttpWebResponse response) at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryGetResponseAsyncCallback(IAsyncResult asyncResult)} I need help with this asap to solve a production issue.

    S 1 Reply Last reply
    0
    • S sheldons

      HEEEEEEELP! I am executing this as an async query with the the following caml below. I keep getting an error returned.

      <View>
      <FieldRef Name='myID' />
      <FieldRef Name='ContentType' />
      <FieldRef Name='DocName' />
      <FieldRef Name='myFirstName' />
      <FieldRef Name='myLastName' />
      <Query>
      <Where>
      <And>
      <In>
      <FieldRef Name='ContentType' />
      <Values>
      <Value Type='Text'>CT1</Value>
      <Value Type='Text'>CT2</Value>
      <Value Type='Text'>CT3</Value>
      <Value Type='Text'>CT3</Value>
      </Values>
      </In>
      <Eq>
      <FieldRef Name='myID' />
      <Value Type='Text'>{0}</Value>
      </Eq>
      <IsNull>
      <FieldRef Name='AnotherID'></FieldRef>
      </IsNull>
      </And>
      </Where>
      </Query>
      </View>

      Below is the message and exception that I am getting back. Message: "Cannot complete this action.\n\nPlease try again." Exception: {Microsoft.SharePoint.Client.ServerException: Cannot complete this action. Please try again. at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream) at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse(HttpWebResponse response) at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryGetResponseAsyncCallback(IAsyncResult asyncResult)} I need help with this asap to solve a production issue.

      S Offline
      S Offline
      sheldons
      wrote on last edited by
      #2

      To build further on this. The problem I am having is with the following:

      <IsNull>
      <FieldRef Name='AnotherID'></FieldRef>
      </IsNull>

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups