I have a large list (with item count > 5000) with invoice positions, which I want to be filtered by a lookup field (invoice header ID).
- I tried to filter the list extending the URL, i.e.: ...FilterField1=InvoiceID&FilterValue1=185
- I made a view with a hardcoded condition: InvoiceID=185
- I tried to open a Dropdown for filtering the column
Every time I get a “throttling” exception, that says the list is too large, although the lookup column is indexed. For indexed fields of any other types (text, number) filtering works OK. Does anybody know a solution to this problem ?