Maybe I’m not using the Data Services right. But, while checking the data through Automation Cloud Portal I’ve seen that you can only sort and filter records that are being displayed in the current page you are looking at.
For example, if I have a 100 records, the most I can visualize are 50. If I tried to sort them by any of the fields or search, it will only filter or sort the records I’m currently visualizing. Since Records are being introduced into the list in a chronological basis, it’s really dificult to visualize them correctly from the platform.
You should be able to sort and filter all records in an data entity.