Add multiple Fields For the CamlQuery in Sharepoint Hosted App

Question

I am trying to filter two fields or more that is clean of null values.

It works for the first field but it is not working for the second field:

<View><Query><Where><IsNotNull><FieldRef Name='CustomField'/></IsNotNull><IsNotNull><FieldRef Name='LaborCategory'/></IsNotNull></Where></Query></View>

Answer 1

You need nested query. For each column you need to add AND/OR in query. See this answer https://stackoverflow.com/a/6204309/4069473

Answer 2

Try using below CAML query:

<View>
  <Query>
    <Where>
      <AND>
        <IsNotNull><FieldRef Name='CustomField'/></IsNotNull>
        <IsNotNull><FieldRef Name='LaborCategory'/></IsNotNull>
      </AND>
    </Where>
  </Query>
</View>

Official documentations:

1. IsNotNull element (Query)
2. CAML Query schema

Answer 3

Even though this question is already answered. I would still recommend you to use U2U which will help you create and understand complex CAML queries in the future.