Retrieving Database Records

Automate database record retrieval with the Database Book.

Retrieving All Records

To retrieve all the records from a specific table in your database, use the following syntax, replacing table with the table name.

Syntax

get a database's {table}

Examples

get a database's User

get a database's person

get a database's EmployeeData

Retrieving Specific Records

To filter records based on specific criteria, use the whose keyword followed by the filter conditions. You can also combine multiple filter conditions using the and keyword.

Syntax

get the database's {item} whose {field} is {value}

Examples

get a database's WorkOrder whose ID is 3

get a database's person whose FirstName is "Jane" and whose LastName is "Doe"

Storing Retrieved Records

After retrieving records from the database, you can store them in an automation for later reference. To do this, use the following phrase, replacing plural data name with any meaningful plural term.

use the above as the {plural data name}

To reference a specific record within the retrieved database records, write an additional line using positional keywords like first, second, etc.

use the {position} record as the {singular data name}

Example

In the following example:

• All the retrieved database records from the query are stored as the records.

• Only the first database record is stored as the employee.

get a database's person whose FirstName is "Nancy"
use the above as the records
use the first record as the employee