Field Name

Description

Name

Enter a unique name for the Application Rule.

Rule Type

Only the Execution Rule type is supported.

Execution Type

Displays the Execution Type as JSON Read From DB.

Table Name

Enter the table name from which you want to read the data.

Column List

Enter the column names of the selected table.

Where Condition

Enter the filter condition (where clause) of the SQL query.

Return JSON Type

Select the JSON type of the returned value as JSON Object or JSON Array based on your requirement.

·       JSON Object- Select this option if the returned value is a single row.

·       JSON Array- Select this option if the returned data has multiple rows.

Output DataField

Select the DataField to which you want to return the value of the SQL query, from the drop-down list.

Scope

Select the scope of the Application Rule from the drop-down list. The options are:

·       Process- Select Process if you want to use the Application Rule only in the current process.

·       Package- Select Package if you want to use the Application Rule across all the processes in the Application package.