Hi there,
I create an entity, how to get the database name of this entity?
regards
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()
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.
Hi thank,
but which part says the DB name?
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 ?