Query to get all entity name of a esapce

Query to get all entity name of a esapce

  

How can we get all entity names of a espace though a query

Hi,

There is a system table called Entity that you should use for this.

Let me know if you have any trouble,

Justin

@Justin  

How we can get all entity of espace  like if espcae have multiple modules then how we can get the entity from all module of application/espcase 


Hi A,

There is a system table 'Espace_Entity' that bridges the 'Entity' table with the 'Espace' table.

Let me know if this helps,

Justin

Hi A,

First you need to get the EspacId from Ossys_espace table then you have to run this query

Select * from Ossys_espace_entity where espace_id= your espaceId


Regards

-PJ-