Version: 4

Select Rows

The Select Rows action allows you to select multiple rows identified by their unique identifiers in the table.

Action Conditions

Action condition	Description
Table	Select the table from which you want to retrieve a record.
The fields to be retrieved	Select the fields whose values you want to retrieve. Enter * (asterisk) to retrieve all the records.
WHERE Condition	Enter the conditions using the WHERE clause to specify unique identifiers in the table that uniquely identify the rows you wish to select and retrieve. Following is an example of a WHERE clause condition: WHERE CUSTOMER_ID = 12345

Action condition

Description

Table

Select the table from which you want to retrieve a record.

The fields to be retrieved

Select the fields whose values you want to retrieve.

Enter * (asterisk) to retrieve all the records.

WHERE Condition

Enter the conditions using the WHERE clause to specify unique identifiers in the table that uniquely identify the rows you wish to select and retrieve.

Following is an example of a WHERE clause condition:

WHERE CUSTOMER_ID = 12345

Action Conditions​

Action Conditions