How to manage Multiple OR Condition in CAML Query for Sharepoint List in SPFx

Question

Multiple OR Condition not Working..
const camlQuery = `

    

       

          

             

             ${currentCategory}

          

          

             

                

                All Users

             

             

                

                Test

             

          

       

    

 `

Above query is working

Below Query Throw Error :

Only 2 OR condition works..

Error : {

"code": "-2147024809, System.ArgumentException",

"message": "Value does not fall within the expected range."

}

Answer

Hi @Hanumant Soft - Dev ,

Since you are not allowed to put more than two conditions in one condition group (And | Or) you have to create an extra nested group (MSDN). The expression looks like this:

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer

I have used below code for the CAML query but empty result returns..actually having values to return based on condition :
below code generate following CAML query.
we have data for "Favorite" Category anf for "All Users" AccessGroup
how to fix it

 async buildCamlQuery(values: string[], category: string) {
    const fieldRefXml = (value: string) => `
      
        
        ${value}
      `;

    const wrapWithOr = (conditions: string[]) => {
      if (conditions.length === 1) {
        return conditions[0];
      }
      return `
          
            ${conditions.shift()}
            ${wrapWithOr(conditions)}
          `;
    };

    const buildOrConditions = (values: string[]): string => {
      const conditions = values.map(value => fieldRefXml(value));

      const result: string[] = [];
      while (conditions.length > 0) {
        const batch = conditions.splice(0, 2);
        result.push(wrapWithOr(batch));
      }

      if (result.length === 1) {
        return result[0];
      }

      return wrapWithOr(result);
    };

    const orConditions = buildOrConditions(values);

    return `
      
        
          
            
              
                
                ${category}
              
              ${orConditions}
            
          
        
      `;
  }

  async filterUsingGroup(category) {


    //const userGroups = await this.getUserGroups();
    const userGroups = ['All Users', 'ArgosPlus', 'grp1', 'grp2'
      //,     'grp3', 'grp4', 'grp5', 'grp6', 'grp7'
    ]


    userGroups.forEach(element => {
      console.log(element.replace("'", "").replace("'", ""))
    });
    let camlQuery = await this.buildCamlQuery(
      userGroups

      //['All Users', 'ArgosPlus']
      , category);
    console.log("MERGED : ", camlQuery)


    const body = {
      query: {
        ViewXml: camlQuery,
      },
    };

    const options = {
      body: JSON.stringify(body),
    };
    const tenantUrl = common.getTenantUrl(
      this.props.context.pageContext.web.absoluteUrl
    );
    await this.props.context.spHttpClient
      .post(
        `${tenantUrl}/sites/Corporate-Technology/sandbox/_api/web/lists/getbytitle('${UrlConstant.businessApp.BUSINESS_APP_LIST}')/GetItems`,
        SPHttpClient.configurations.v1,
        options
      )
      .then(async (response: SPHttpClientResponse) => {
        console.log("CAML 1 : ", await response.json());
        //return response.json();
      });


  }

Share via

How to manage Multiple OR Condition in CAML Query for Sharepoint List in SPFx

2 answers