This question already has an answer here:
I have a list with a lookup column in it. (name: colParent)
I can query the list with Eq, and get the correct results (2 results returned for 224).
<Eq> <FieldRef Name='colParent' LookupId='TRUE' /> <Value Type='Lookup'>224</Value> </Eq>
However, I do the same query with "In", and get no results.
<In> <FieldRef Name='colParent' LookupId='TRUE' /> <Values> <Value Type='Lookup'>224</Value> </Values> </In>
(in the actual query, there will be multiple lookup Ids, so I need to use "In")
What's even weirder - this list is in a SP-hosted app that I developed. I installed the app in 2 sites. The "In" query works in one, but not in the other. So the query should be correct, its just not working in one site.
Any ideas? I'm going crazy over this one.