How to get list of elements (Actions, Entities and Screens) using System entities?

Hi,


Does anybody know how to get the list of elements of an Espace using Outsystems System entities? 


Example:

EspaceName      ElementName      Type    

Work_CS             SaveAction            Action

Work_CS             TestEntity               Entity


P.S. please do not suggest to use lifetimeAPI "ModuleVersion_Get"


Thank you,

Hanz

I don't know if I understood what you want, but I belive that you need to do some query like this:

SELECT es.NAME AS 'eSpace Name',
       et.NAME AS 'Table Name',
   et.PHYSICAL_TABLE_NAME AS 'Phisical Table Name'
FROM   ossys_entity et
       LEFT JOIN ossys_espace es
              ON et.espace_id = es.id


if you have access (permissions) to the database.

Nuno Miguel Verdasca wrote:

I don't know if I understood what you want, but I belive that you need to do some query like this:

SELECT es.NAME AS 'eSpace Name',
       et.NAME AS 'Table Name',
   et.PHYSICAL_TABLE_NAME AS 'Phisical Table Name'
FROM   ossys_entity et
       LEFT JOIN ossys_espace es
              ON et.espace_id = es.id


if you have access (permissions) to the database.

Hi Miguel,


Thanks for the idea. But this only shows espace Entities. I also need to display what are the Actions and WebBlocks inside the espace.