We have a list, the items will be added everyday by scheduled job.
The number of items varies around 5000 to 12000 every day..
The list has columns like:
- Country: Lookup
- City: Lookup
- StartDate: Date
- EndDate: Date
- Other columns
In our application we need to fetch the details from the list for today for the selected country from drop-down.
Is it feasible to use the below query to fetch only records for the selected country and for today's interval instead of recursive function to fetch items?
https://sites.test.com/sites/test/_api/web/lists/getbytitle('test')/items?$select=Title,City/Id,City/Title,ID,Country/Id,User/Id,User/EMail,User/Title,User/SipAddress,User/Department&$expand=Country,City,User&$filter=Country/Title eq 'UK' and StartDate le datetime'2019-03-12T00:00:00' and EndDate ge datetime'2019-03-12T00:00:00'&$orderby=Title&$top=4999