Content Freeze
As of July 25th, 2023, there is a content freeze on this page.
This action finds and retrieves a database record.
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.
Where do you want to place the record?
The record data can be placed on the screen, into a work variable, or into a 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.