CAML Query not running

[Phil Meacham]

On the vLookup condition editor, I need to have 3 AND statements. The GUI only allows 2 so I’m trying to write it in CAML.

I’ve used a CAML builder and tested my code and it works perfect, but for some reason it’s like code keeps being ignored and it just keeps bringing back the results without the 3rd AND.

My CAML code is:

<Query>
<Where>
<And>
<Eq>
<FieldRef Name=”Staff_x0020_Name” LookupId=”False”/>
<Value Type=”Lookup”>[currentItem:Staff_x0020_Name]</Value>
</Eq>
<And>
<Eq>
<FieldRef Name=”Property” />
<Value Type=”Text”>[currentItem:Property]</Value>
</Eq>

<Eq>
<FieldRef Name=”Agreed” />
<Value Type=”Text”>True</Value>
</Eq>

</And>
</And>
</Where>
</Query>

Any help would be greatly appreciated!

[Alexander Bautz]

Hi,
The CAML should not include the tag – try removing these tags and try again.

Alexander

[Author]

Posts