The Plant Database data source functions are customizable in the following ways:
Global changes can be made to the standard functions. The functions can be removed, renamed, or mapped to other nodes in the mirrored Plant Model tree. You can also change the names of the parameters (if applicable) and returned columns.
CAUTION: The changes that are made to the functions at this level are global changes. They will affect all Plant Database data sources. Functions that are already used in displays can also be affected.
New functions can be added or changed. New functions apply only to the specific data source they are added to; that is, it is not a global change. Refer to Adding Plant Database Functions for more information.
If you have not already done so, create a new Plant Database data source. How?
In the Add New Plant Database Data Source window, click Configure Functions. You will be asked to confirm that you want to make changes to global functions. Click Yes.
A list of standard queries (functions) appears.
Select the function you want to copy.
Click the Copy button.
The Procedure Call Configuration dialog box appears. Here you can change the name of the function and customize parameters and columns for the function. Refer to To edit functions for detailed information.
Click Save to apply your changes.
If you have not already done so, create a new Plant Database data source. How?
In the Add New Plant Database Data Source window, click Configure Functions. You will be asked to confirm that you want to make changes to global functions. Click Yes.
Select the function you want to remove.
Click the Remove button. The function is removed from the list.
Click Save to apply your changes.
If you have not already done so, create a new Plant Database data source. How?
In the Add New Plant Database Data Source window, click Configure Functions. You will be asked to confirm that you want to make changes to global functions. Click Yes.
Select the function you want to configure.
Click the Edit button. The Procedure Call Configuration dialog box appears.
Make any or all of the following changes:
In the Procedure Call Name box, enter a new name for the function.
From the Data Model Node Type list, select the level of the Data model that you want the function to appear at.
If there are Parameters for the function, on the Parameters tab, enter a new Description and/or Default Value.
Click the Results tab.
For each column you can enter an new Column Description. This description will appear as the column header (e.g. a column label in a grid object).
Click OK on the Procedure Call Configuration dialog box.
Click Save to apply your changes.
Open the Administration application.
Click the Connectors & Data Sources button.
Expand the Plant node and select Plant Database.
On the Add New Plant Database Data Source window, click Configure Functions. You will be asked to confirm that you want to make changes to global functions. Click Yes.
Click the Defaults button. The Reset from defaults dialog box appears.
If you want to restore all standard features, accept the default --All Standard Queries-- and click OK. You will be asked to confirm your request to revert to the original list, since all changes made to the original configuration will be lost. Click Yes.
- or -
If you want to restore one function only, select the function from the Restore list and click OK.
Click Save to apply your changes.
Restart the Proficy Portal server.
Return to the Administration application (Connectors & Data Sources).
Expand the Plant node and select the Plant Database data source.
Click the Reset Browse Cache button.
Click the Resent Browse Cache button on any other Plant Database data sources if they exist.
