61
Views
4
Comments
Solved
How to get database name of an entity?
Question
Application Type
Reactive

Hi there,

I create an entity, how to get the database name of this entity?

regards

2025-01-09 14-56-57
IQ78
Solution

Thank U, Sir

I found different DB in Cloud and also in another server, like this:

And my case is here:

https://www.outsystems.com/forums/discussion/97625/sql-sandbox-invalid-object-name-39osusr-wgmyentity/

And now i nail it as in a premise server, when we create a module we need to choose a database catalog.

And using advance query, it works now by using this syntax:

use xxxDB

select *

from {AuditTrail}

========================

Note, in Advance query, we can select the database name:

SELECT DB_NAME()


regards






2019-01-07 16-04-16
Siya
 
MVP

Add a reference to the (System) -> Entity. The Entity -> Physical_Table_Name will give you the database name of the entity. You need to filter by EspaceId and your entity name.

2025-01-09 14-56-57
IQ78

Hi thank,

but which part says the DB name?


regards

2019-01-07 16-04-16
Siya
 
MVP

There are 3 databases when you install a platform server - OutSystems, OutSystemsLogs & OutSystemsSession. Configuration of this is done inside a Configuration Tool. 

From Entity table you will not be able to make out the database name. Normally the entities are stored in OutSystems Database.

Btw what's your use case ?

2025-01-09 14-56-57
IQ78
Solution

Thank U, Sir

I found different DB in Cloud and also in another server, like this:

And my case is here:

https://www.outsystems.com/forums/discussion/97625/sql-sandbox-invalid-object-name-39osusr-wgmyentity/

And now i nail it as in a premise server, when we create a module we need to choose a database catalog.

And using advance query, it works now by using this syntax:

use xxxDB

select *

from {AuditTrail}

========================

Note, in Advance query, we can select the database name:

SELECT DB_NAME()


regards






Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.