I'm dealing with a set of interconnected entities structured as follows:
Entity1 -> Entity2 -> Entity3 (illustrating one-to-many relationships with arrows)
I am utilizing MikroORM for this purpose.
Is there a way to construct a findAndCount query that can sort the results of Entity1 based on Entity3's updatedAt field?
I anticipate receiving a sorted list of Entity1 objects based on Entity3's updatedAt property