Question & Answer > View Question

Can I change the table prepend (app_fd_) or add a envVariable in a table name?

Confluence User - 04 Oct, 2017

I would like to create a test version of an app on the same server as the live version which does not use the data tables of the live version. To accomplish this can I somehow change the table prepend (app_fd_) for that single test application or add an environmental variable in a table name so that the test version of the application writes to a different set of tables? This would preclude the need for a second test server and the need to recreate the user organization on that separate server to validate permissions/access in the test environment.

Thanks, Bill

server;tables;user

3

Confluence User •

06 Oct, 2017 •

confluenceUser •

•

confluenceUser •

Hi, I'm not aware of a built-in way to do it, but I'm pretty sure it would be possible using a custom Form Load/Options/Store Binder Plugin. However I'm not sure it's a good idea to mix test and production in a single environment, I personally would recommend separating them.

Confluence User •

06 Oct, 2017 •

confluenceUser •

•

confluenceUser •

I would recommend you setting up another server for testing purpose. God knows when things will go wrong when you do testing on production.

Confluence User •

29 Oct, 2017 •

confluenceUser •

•

confluenceUser •

Agreed! However, duplicating an app for another purpose would be easier if the tables names could all be changed via an environmental variable.

1

CSV | Excel | XML | PDF

Your answer

Print

Can I change the table prepend (app_fd_) or add a envVariable in a table name?

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-cd8ed637-df8f-4727-a2df-a60a1f28be08{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-2d3078e3-48c7-4ad0-8c42-b161e61f1526{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer