I have created a application where there are 30 espaces .I need a query which can give me all the entities in all espaces belonging to this application.
Look in System, you will see the "Application" Entity, join to App_Definition_Module, join to Module, which can then be joined to Espace or Extension entities as needed.
J.Ja