Skip to Content (Press Enter)
UserImage.jpg
DING WEIBING
520Views
7Comments
Solved
How to get each entity names from specific module?
Question

Hi guys. Iam try to build a micro database management system, use to do some data import and export. First i need to list each entity name in my module. How could i get that list ?

0
0
08 Jul 2019
Copy Link
2024-12-17 14-32-59
Matthias Preuter
 
MVP
Solution

The low code way:

First Add reference to the system entities:

  • espace
  • entity

Then create a Aggregate with these entities; to get entities for a specific module (fka espace) set a filter on espace.name.


The SQL widget way:

Also add reference to the system entities, and use the outsystems-entity name (between curly brackets) in the SELECT statement:

See solution in context
0
0
08 Jul 2019
Copy Link
UserImage.jpg
DING WEIBING

Matthias Preuter wrote:

The low code way:

First Add reference to the system entities:

  • espace
  • entity

Then create a Aggregate with these entities; to get entities for a specific module (fka espace) set a filter on espace.name.


The SQL widget way:

Also add reference to the system entities, and use the outsystems-entity name (between curly brackets) in the SELECT statement:

Hi Matthias Preuter,

  Thanks for your help.

  It works perfectly for me.

0
0
08 Jul 2019
Copy Link
2025-08-22 10-19-44
Pramod Jain
 
MVP

Hi Ding,

Outsystems store the entities details like Physical Name & Logical Name in one of the platform entity named (OSSYS_ENTITY) and it stores it with Espace id . So you can put some logics to get the Espace Id by its name and than get the entity names.



Regards,

-PJ-


1
0
08 Jul 2019
Copy Link
UserImage.jpg
DING WEIBING

PRAMOD JAIN wrote:

Hi Ding,

Outsystems store the entities details like Physical Name & Logical Name in one of the platform entity named (OSSYS_ENTITY) and it stores it with Espace id . So you can put some logics to get the Espace Id by its name and than get the entity names.



Regards,

-PJ-


Hi PRAMOD JAIN

Thanks for your help.

I tried to used SQL widget with "SELECT * FROM Ossys_entity;" , i got error says Ossys_is a reserved prefix in SQL1.

0
0
08 Jul 2019
Copy Link
UserImage.jpg
DING WEIBING

PRAMOD JAIN wrote:

Hi Ding,

Outsystems store the entities details like Physical Name & Logical Name in one of the platform entity named (OSSYS_ENTITY) and it stores it with Espace id . So you can put some logics to get the Espace Id by its name and than get the entity names.



Regards,

-PJ-



0
0
08 Jul 2019
Copy Link
2024-12-17 14-32-59
Matthias Preuter
 
MVP
Solution

The low code way:

First Add reference to the system entities:

  • espace
  • entity

Then create a Aggregate with these entities; to get entities for a specific module (fka espace) set a filter on espace.name.


The SQL widget way:

Also add reference to the system entities, and use the outsystems-entity name (between curly brackets) in the SELECT statement:

0
0
08 Jul 2019
Copy Link
UserImage.jpg
DING WEIBING

Matthias Preuter wrote:

The low code way:

First Add reference to the system entities:

  • espace
  • entity

Then create a Aggregate with these entities; to get entities for a specific module (fka espace) set a filter on espace.name.


The SQL widget way:

Also add reference to the system entities, and use the outsystems-entity name (between curly brackets) in the SELECT statement:

Hi Matthias Preuter,

  Thanks for your help.

  It works perfectly for me.

0
0
08 Jul 2019
Copy Link
2025-08-22 10-19-44
Pramod Jain
 
MVP

Hi Ding ,


Please try how Matthias explained and see if solves your problem.


Regards,

-PJ-

0
0
08 Jul 2019
Copy Link
UserImage.jpg
DING WEIBING

PRAMOD JAIN wrote:

Hi Ding ,


Please try how Matthias explained and see if solves your problem.


Regards,

-PJ-


Hi PJ,

Thank you so much.

It works perfectly for me.

0
0
08 Jul 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.