JSON Read From DB Application Rule

This Application Rule is used to read data from the database in JSON format.

Figure 4-18 JSON Read from DB Rule Details window

Table 4-14 JSON Read from DB Rule Details Description

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.