I want to query for items where a lookup has a title which contains some text.
The list has over 5000 items, but the query result will return fewer, so it should work.
This query works, querying for title:
<Contains><FieldRef Name='Title' /><Value Type='Text'>test</Value></Contains>
This query does not work, querying a lookup:
<Contains><FieldRef Name='MyLookup' /><Value Type='Lookup'>test</Value></Contains>
Both fields are indexed. I don't want to first fetch IDs for the lookup list items (
LookupId works, but only on ID). I have tried
Type='Text'. I have tried with