I am using the SP
Lists service, the
GetListItems method as follows (
guidView is set to the "All Items" view):
listasSoap.getListItems( guidList, guidView, null, viewFields, "0", null, "");
And getting back all 22069 items.
Now, I retrieve the contents of the
ows_Contrato field of one of those items, who happens to be, for example:
And try the following queries:
<Query><Where><Eq><FieldRef Name="Contrato"/><Value Type="Lookup">667;#ABAP14</Value></Eq></Where></Query> <Query><Where><Eq><FieldRef Name="Contrato" LookupId="True"/><Value Type="Lookup">667</Value></Eq></Where></Query>
But those queries return 0 items (despite the values being copy pasted from the
I am generating the query Strings and SOAP object programmatically, and they work as they should for other lists. Yet no matter how many times I try, I cannot retrieve any items (0 elements with "z:row" tag name).
where directly to the ID works as expected.
<Query><Where><Eq><FieldRef Name="ID"/><Value Type="Counter">23984</Value></Eq></Where></Query>
What could be the issue that I am facing? As I said, other lists of the site work perfectly with similar queries.
The client is Java, the server is SharePoint 2007.