I have been running around in circles trying to figure out why one of my lists wouldn't pull any results when querying based on a Lookup value. When I disabled indexing on the lookup column it suddenly worked!
Is this behavior expected (that is, do other's experience it) and is there a workaround or should I explore more why my query isn't working? I'm using SP2007.
Here is my query code (note if I change this query to a non-indexed field or if I use the exact same query but turn off the index it works):
var langaugeID = 26;
var colLangName = 'Language';
var query = '' +
'<FieldRef Name="' + colLangName + '" LookupId="TRUE" />' +
'<Value Type="Lookup">' + languageID + '</Value>' +