Retrieve a Set of Database Records
- Al Lusher (Unlicensed)
- Jessica Tomkins
This action retrieves a list of database records.
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.
Which columns? Select columns and enter optional column aliases.
Select the columns you'd like to retrieve as part of this operation. You can also enter optional column alias for each of the columns selected.
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.
Specify order by
Check this box to sort the records in a specific order.
Select column(s)
Select one or more columns to sort by. The default sort order is ascending. To change the order to descending, manually type the DESC keyword after the column name.
Limit number of records to retrieve
Type in a number to indicate the maximum number of records to retrieve. For performance reasons, if you are querying against a very large databae table, it is a good idea to set a reasonable limit.
Number of records to skip before retrieving
Type in a number to indicate the number of records to skip before retrieving. When used with limit it allows for creating server side paging.
Where do you want to place the records?
The records can be placed into a grid, work variable, or 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.
