0
  • I am trying to execute below condition in REST , But OData in Rest doesn't support null . I would like to execute below condition in CAML Query and Pass to REST.
  • Tried using CAML Query ,But I am getting mismatch result.

Can any one please do let me know who can make caml query for my below cnoditons

country=USA or UK or India or UAE or France AND ProductCategory=NULL AND Products!=NULL or Grains

Improve this question
2
  • u2u.be/software > U2U Caml Query Builder Commented Jun 8, 2018 at 6:53
  • Sir, Software's are not allowed .Could you please extend your help Commented Jun 8, 2018 at 6:57

1 Answer 1

Reset to default
0

Try this one (replace your internal field name and field type)

 <And> <And> <Eq><FieldRef Name='Country'/><Value Type='Text'>USA</Value></Eq> <Or> <Eq><FieldRef Name='Country'/><Value Type='Text'>UK</Value></Eq> <OR> <Eq><FieldRef Name='country'/><Value Type='Text'>India</Value></Eq> <Eq><FieldRef Name='Status'/><Value Type='Text'>UAE</Value></Eq> </Or> </Or> </And> <And> <IsNull><FieldRef Name='ProductCategory' /></IsNull> <And> <IsNotNull><FieldRef Name='Product' /></IsNotNull> <Neq> <FieldRef Name='Product' /> <Value Type='Text'>Grains</Value> </Neq> </And> </And> </And>
Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.