May 19 2021 03:36 AM
I have a problem running a CAML query. I get a 0x80131904 exception.
My input data are the following one:
MasterList contains the following columns:
SampleData are:
Title MyTextColumn MyCalculatedColumn Peter Paris Paris_Peter Arnold Paris Paris_Arnold Gabriel Nice Nice_Gabriel
SecondList contains the following columns:
SampledData are:
Title MasterItem MasterItem:MyTextColumn MasterItem:MyCalculatedColumn Item1 Arnold Paris Paris_Arnold Item2 Arnold Paris Paris_Arnold Item3 Gabriel Nice Nice_Gabriel Item4 Peter Paris Paris_Peter Item5 Gabriel Nice Nice_Gabriel
Now I want to run CAML queries on SecondList:
This CAML query runs OK and returns 2 rows as expected:
<Query> <Where> <Contains> <FieldRef Name="MasterItem" /> <Value Type="Lookup">Gabriel</Value> </Contains> </Where> </Query>
This CAML query runs also OK and returns 3 rows as expected:
<Query> <Where> <Contains> <FieldRef Name="MasterItem_x003a_MyTextColumn" /> <Value Type="Lookup">Paris</Value> </Contains> </Where> </Query>
BUT...this CAML query fails with an exception...and I did not find any restriction in documentation
<Query> <Where> <Contains> <FieldRef Name="MasterItem_x003a_MyCalculatedCol" /> <Value Type="Lookup">Paris</Value> </Contains> </Where> </Query>
Can someone tell me how I should format my last query for letting work.
The XML of the queries are extracted from the SmartCAML app that I used to test CAML queries...
Regards.