Local DB Count

The Local DB Count action provides a count of rows for a Local Database table. An optional Where clause can be used.

Parameter descriptions

Parameter	Description
Table	The name of the local database table for the count operation. The table name will be available from a drop-down list.
Where	A Where clause can be used to restrict the rows counted. Both constants and substitution variables can be used in the Where clause. To construct a Where clause, use an operator (=, !=, >, >=, <, <=, like, is null, is not null ) to relate the column to either a constant or a substitution variable. Each of these operators can be combined with other operators using an And or Or statement. To use a substitution variable, insert $(x) where x is a variable that will be associated to a variable on the Input tab (see the Input tab below). Note: For columns of type TEXT, the constant or substitution variable must be enclosed in double quotes. For example: C01 = "JohnDoe" The constant is enclosed in double quotes. C01 = "$(test)" The substitution variable is enclosed in double quotes. The variable (test in this example) will be added to the Input tab and can then be mapped to a STRING variable (or a constant). The Where clause builder, accessed by selecting the icon , can be used to assist in building the Where clause. For more information on the Where clause builder, see Local DB Select.

Parameter

Description

Table

The name of the local database table for the count operation. The table name will be available from a drop-down list.

Where

A Where clause can be used to restrict the rows counted.
Both constants and substitution variables can be used in the Where clause.
To construct a Where clause, use an operator (=, !=, >, >=, <, <=, like, is null, is not null ) to relate the column to either a constant or a substitution variable.
Each of these operators can be combined with other operators using an And or Or statement.
To use a substitution variable, insert $(x) where x is a variable that will be associated to a variable on the Input tab (see the Input tab below).

Note: For columns of type TEXT, the constant or substitution variable must be enclosed in double quotes. For example:

C01 = "JohnDoe"
The constant is enclosed in double quotes.
C01 = "$(test)"
The substitution variable is enclosed in double quotes. The variable (test in this example) will be added to the Input tab and can then be mapped to a STRING variable (or a constant).

The Where clause builder, accessed by selecting the icon , can be used to assist in building the Where clause.
For more information on the Where clause builder, see Local DB Select.

Input tab

Optional. The Input tab will only appear if a Where clause is specified and the Where clause contains a logical variable (for example, $(VariableName)).

There will be as many rows in the Input tab as there are logical variables in the Where clause.

Parameter	Description
Logical Variables from the Where clause	Required. The variable whose value is to be substituted in the Where clause logical variable. This variable can be any type of variable in the system.

Output tab

Parameter	Description
Result Count	The number of rows return by the count, based on the Where clause.
Error Message	Optional. Used to provide information if the count fails.

Local DB Count

Related topics