Skip to end of banner
Go to start of banner

How to add a word "test" to all the organization units

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

For the Test system, it is usually advisable to update all the organization units and add the word "test" in the end.

It is required to avoid possible confusion between Test and Production when they are open at the same time.

To add the word "test" run the below SQL statement.

Update PWORG
SET NAME = LEFT(NAME, 33) + ' (test)'
Where ORGTYPE in (1,2,3,4)

After the above update the organization units would look like that:

  • No labels