125
Views
5
Comments
Entity Original Name
Question

Hi,

I wonder if there is a way to get the original name of the entity attribute.

As in the sql server, the original name starts with number, however, the outsystems automatically cut the number in the name.

Thank you.

2021-08-12 11-00-27
Nordin Ahdi
 
MVP

Hi Hailey,

The title of your post suggests you are looking for the physical table name, but you are looking for the original name of an entity attribute right?

I do not think there is a way to retrieve the original name of an entity attribute since that specific property is only available in external entities' attributes.

The original name attribute is also not available in the Entity_Attr metadata.

Hope this helps!

Regards,

Nordin

2020-04-17 08-41-30
Tim Timperman

I'm pretty sure the original name is the "Database_Name" column in that list.

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Tim Timperman wrote:

I'm pretty sure the original name is the "Database_Name" column in that list.

 "Database_Name"  is the name of the column if the entity is from an external database, this is NOT the internal OutSystems table column name. So it is only filled for entities of external (non-outsystems) tables. For OutSystems generated tables that attribute is empty.

 

2021-08-12 11-00-27
Nordin Ahdi
 
MVP

I must have missed that one, thanks Tim you are right. 

I have just verified that through the Database_Name column of the Entity_Attr  system entity, you should be able to retrieve the Original Name value of an entity attribute that belongs to an external/extension entity.

Regards,

Nordin

2020-04-17 08-41-30
Tim Timperman

Oh, I assumed this question was about an external database. I've never had an internal table where the database column name is not the same as the entity attribute name. So I assumed the question was about an external database.

But your explanation is completely correct, Daniël. Thanks for clarifiying.

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