Why is there limitation on filtering, sorting, or using as dynamic page ?

Got it. It seems weird, you are right. One solution is to get the collection you need, filtered and then sort it out later, in an array of objects.