I have an SP list with 6000 items.It contains 10 lookup columns. I want to filter,retrieve and display a set of items in a page based on these lookup value.
I tried using REST API & CSOM but I am getting an error saying that the threshold has been reached whenever I try to filter based on lookup column.The URL used in REST API is given below.
url:"sites/mysite/_api/Web/Lists/GetByTitle('Details')/Items?$select=Title,Sector/Title&$expand=Sector/Title&$filter= Sector/Title eq 'Banking'",
Also I want to filter based on Title of lookup.