I have CAML queries performed against SharePoint Online lists through SPServices that have worked beautifully for 5 years. Sometime in the last couple of weeks they started returning incorrect results. The problems all seem to be oriented around the "EndOfLife" text field which always contains a "1" or a "0" (without the quotes).
<Where> <Eq> <FieldRef Name='EndOfLife'></FieldRef> <Value Type='Text'>1</Value> </Eq> </Where>
Executed through SPServices in the browser, this query against a particular list returns 10 results. The same query against the same list executed through U2U CAML Query Builder returns over 900 results.
Executed against a different list in another site collection, that query returns 3 results through SPServices in the browser and 2000 results through U2U CAML Query Builder.
There are no changes on my end that correlate with the timing of these problems.
Any idea why these queries executed through SPServices in the browser would suddenly be returning incorrect results?