Skip to Content (Press Enter)
2022-05-18 07-58-50
Pradip Chavhan
35Views
3Comments
Unable to find database table in the outsystems
Question
Reactive
Architecture
Best Practices
Database
Traditional Web
Application Type
Traditional Web, Reactive

I have 1 database table, i know the name of the table and the database name.

But I need help finding its Entity in the outsystems.

How can I get the Entity name from the database table name? 

0
0
15 Dec 2023
Copy Link
2024-05-08 06-29-37
Prince Aadil Khan Panwar

Hi Pradip Chavhan

are you using integration studio for integration the database?

Prince

0
0
15 Dec 2023
Copy Link
2022-07-03 17-24-08
Sourabh sharma

Hi Pradip Chavhan,

We have data tab in that we have all table(Entities ) you can go through that or search by the Name in same module or other Modules .

If you have configured the external database you can open the Integration and, in Data Tab you can get the all tables .


Hope this will help you


0
2
15 Dec 2023
Copy Link
2019-09-30 07-35-56
Aurelio Junior

Hello,

You can do this with a SQL node in an OutSystems application. Add references to the {Entity} and {Espace} entities from the "System" module and run this query:

SELECT {Entity}.[Name], {Espace}.[Name]
FROM {Entity}
INNER JOIN {Espace} ON {Entity}.[Espace_Id] = {Espace}.[Id]
WHERE {Entity}.[Physical_Table_Name] = 'YourTableName'

1
0
15 Dec 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.