Application Configuration Worksheet

Application Configuration worksheet is a system worksheet that must exist in an AlchemyJ workbook. It is automatically added when you click on New Model or Initialize Model in the AlchemyJ ribbon. It contains application properties that can be used in a business logic worksheet in a name-value pair format. Properties in this worksheet will appear in the application configuration yml file.

Refer to Reading application configuration to learn how to use this worksheet to add externalized application properties to your project.

Note: Space is not allowed in the Property column.

There are two built-in properties in the worksheet.

• parameter-separator

The character(s) used to separate multiple parameters in parameter strings of AlchemyJ Extended Functions. The default value is -||-. There is no need to change this unless you expect the parameter value may contain -||-.

Below is an example of using parameter separator in the parameter argument of ajDBRunSQL.

RECORD_ID1-##-21-##-NUMBER-##-IN-||-RECORD_ID2-##-23-##-NUMBER-##-IN-||-OUTPUT-##--##-NUMBER-##-OUT

This property has the Excel name AlchemyJ_Parameter_Separator. It is recommended to use this name to refer to this separator in your formulas.

• parameter-type-separator

The character(s) used to separate multiple parameter properties of a parameter in parameter string of AlchemyJ Extended Functions. The default value is -##-. There is no need to change this unless you expect the parameter value may contain -##-.

Below is an example of using parameter type separator in the parameter argument of ajCustomFunction.

YearOfBirth-##-1990-##-Integer

This property has the Excel name AlchemyJ_Parameter_Type_Separator. It is recommended to use this name to refer to this separator in your formulas.