I have created an
External Content Type using SharePoint Designer. The data source is SQL table. The data in SQL table may increase up to around 25k rows.
To handle this situation, we are using Page Number filter to enable the users to view all items by modifying the views.
The problem is that as soon as I add Page Number type filter in the External Content Type, it disappears from External Content Type picker while creating list.
If I try to create list from SharePoint designer, I get an error
Could not save changes.
I couldn't find any documentation about using Page Number Filter, does it require any additional configuration? Please suggest.
The External Content Type has Read List, Read Item and Update operations.