I have successfully created an external content type to my SharePoint and I have made a list from it. The problem is my table has over 24000 records in it. I need to grab the last 2000 records and not the first 2000 records as it seems to be doing. Is there any way to run a query against the data I am getting to bring in the last 2000 items?
Why don't you create a Stored Procedure that brings the desired Last 2000 items for you, and create Read List Operation from Stored Procedure and rest from the table?
Stored Procedure can look like:
I hope this will work!