i am getting an error in the workflow when trying to query a list in another site inside the same site collection using caml query and other site, when i log the xml it all looks good.
here is the error: Failed to query list data. Object reference not set to an instance of an object.
here is the xml for the caml query
<Query>
<Lists>
<List ID="{8DEC397E-694D-43FD-8496-EAA048F38ED5}"/>
</Lists>
<Where>
<Eq>
<FieldRef Name="EmployeeId"/>
<Value Type="Text">10535</Value>
</Eq>
</Where>
</Query>
Crazy question...what happens if you try doing the exact same thing but without the CAML query. See what happens if you use UI instead.
you cant query a list in another site unless you do a caml query
What about with the 'Call Web Service'?
ok i did the webservice, had to capitalize q in QueryOptions in the soap editor mode
In your CAML query the viewfields are missing, for example :
<Query>
<Lists>
<List ID="{8DEC397E-694D-43FD-8496-EAA048F38ED5}"/>
</Lists>
<ViewFields>
<FieldRef Name="Title"/>
</ViewFields>
<Where>
<Eq>
<FieldRef Name="EmployeeId"/>
<Value Type="Text">10535</Value>
</Eq>
</Where>
</Query>
Hope this helps
thanks that worked, didnt think i needed it since it had a return field and store in under that in the UI, thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.