The post you linked to while old and needing to find it in the internet archive is still relevant and a good place to start.
There simply isn’t any way to filter or order posts by the sub fields or a repeater. If you need to do this then you need to convert these values into something that can be used for this purpose as explained in that old article.
