Skip to Content
0
Dec 23, 2014 at 09:27 AM

Use SharedProperties property in QueryTemplate

30 Views

For a customer we have three environments:

- Development

- QA

- Production

In the workbench we use a lot of QueryTemplates with SQL queries to the specific database (D,QA or P). The prefix of the tables in the databases are depending on the environment.

e.g.

- for Development the prefix of each table is SAPMIDDB,

- for Production the prefix is SAPMIPDB

If I export a Workbench project from Development to Production I have to change the prefix of the tables in all QueryTemplates manually.

My question: Is there a way to use some kind of parameter (maybe in the SharedProperties.mem) so I only have to change this parameter once?