Using Entity Name In Stored Procedure.

On our radar
As the entities name craeted by service studio generates a different physical name (adding some suffix to it)  thus we cannot use the logical name in stored procedures , but some times we may need to use stored procedure (in our case we are redeveloping a existing application which is currently using many stored procedures for complex calculation like billing generation ) but because of the name change i am unable to use stored procedure.

There should be something to control the stored procedure like we control the advance queries.

Created on 9 Apr 2015
Comments (4)
If I'm understanding you correctly, this is a duplicate of this one: https://www.outsystems.com/ideas/1085/execute-stored-procedures-on-database-connections, or perhaps this one: https://www.outsystems.com/ideas/720/database-synonyms-for-the-outsystems-tables
Pramod -

Just use the View4Entity (https://www.outsystems.com/forge/component/339/view4entity/) eSpace to regenerate views for your entities with a "When Published" timer. Have your stored procedure work against those views.

HI Justin,
How does these views work in case of multitanent application ? i have seen the views created by plafrorm has tenant id as suffix in it.
Pramod -

They will have a Tenant_Id column in them, just filter by that.

All the Tenant views are, are views on the base table filtered by Tenant_Id.

If it is really important to you to use tenant-specific views, it would not be particularly hard to modify that component to make them.