18
Views
4
Comments
Get LocalStorage tables unique identifier
Application Type
Mobile

Hello,
I'm a traditional web dev and quite new to low-code and OutSystems (about 8 months). I'm working on a mobile app.

Some of my users in production sometimes get an error related to a missing record in the localStorage.

But the error is generic as possible, as I'm catching all DatabaseExceptions to show the same error to the client.

I would like to add granularity. But at the moment, the ExceptionMessage gives me something like "TACHE_9AYO_WTAZ_S_9A4H2L20MQD5 with id XXXX was not found".

Here's my question : 

In that case, my real table name is "Tache", and not "TACHE_9AYO_WTAZ_S_9A4H2L20MQD5".

However, this table identifier seems to be the same from my mobile app, from the PWA version, and through different environments. I assume this is something static, but I'm not FULLY sure of this.

Do you know where this name is build, if it is possible to change it, or to retrieve it dynamically so I can programatically make the bridge between the table name in ODC and the one used by the running apps ?


Thank you per advance for you help,

Anthony

2024-10-12 12-11-20
Kerollos Adel
Champion

Hallo @Anthony Perrier


Yes, it is possible to retrieve the table names from the OutSystems database. You can do this by querying the Entity metadata table in the OutSystems system database. This table contains useful columns such as:

  • Name: Represents the logical Entity name in OutSystems (e.g., Tache).
  • Physical_Table_Name: Represents the actual physical table name in the database (e.g., TACHE_9AYO_WTAZ_S_9A4H2L20MQD5).

LocalStoragetablesuniqueidentifier.oml
2021-09-06 15-09-53
Dorine Boudry
 
MVP

This is about ODC, no such metadata is made available there

2024-10-12 12-11-20
Kerollos Adel
Champion
UserImage.jpg
Anthony Perrier

Thank you for your reply :)
As @Dorine Boudry mentioned, I'm not able to proceed this way.


However, your point is important in my opinion, because OutSystems has already considered making physical names available to developers. This makes me think it might also be possible in ODC, perhaps in another way.
Has anyone here ever dealt with this before? 

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