Using Entity Name In Stored Procedure.

By Pramod Jain on 9 Apr 2015
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.

Kilian Hekhuis10 Apr 2015
If I'm understanding you correctly, this is a duplicate of this one: http://www.outsystems.com/ideas/1085/execute-stored-procedures-on-database-connections, or perhaps this one: http://www.outsystems.com/ideas/720/database-synonyms-for-the-outsystems-tables
Justin James10 Apr 2015
Pramod -

Just use the View4Entity (http://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.

J.Ja
Pramod Jain13 Apr 2015
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.
 
Justin James13 Apr 2015
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.

J.Ja