Use this action to determine a count of records in a database table that meet certain criteria.
From which database?
If Profound.js has been configured for multiple connections, this allows you to select the appropriate database connection for this step. If a database is not selected, the default connection will be used.
From which database table(s)?
Select one or more tables. If more than one table is selected, you will have to join the tables together.
Selection criteria expression
Provide a WHERE-clause expression to identify the records. Use the dropdown to create the expression without having to write code manually.
Question marks (?) in the expression are used to identify dynamic values, which are also referred to as selection parameter values. For each question mark, you will be prompted to provide a selection parameter value, where you can select or manually type dynamic content.
Where do you want to place the record count value?
The retrieved record count area can be placed into a screen field, work variable, global property, API output, Module output, or a session property.
Enter work variable name
A work variable is accessible by other steps within the same routine. Some work variables, like 'activeGridRecord' are implied and don't have to be explicitely defined by you.
Enter API output property name
The API output object represents the data sent in response to the API request.