Retrieving Database Records

Automate database record retrieval with the Database Book.

Overview

These procedures allow you to get and retrieve records from a database.

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 retrieve specific records from a database table, you can specify filter conditions.

Using a Filter Condition

Use the whose keyword followed by the condition for which to filter.

Syntax

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

Examples

get a database's WorkOrder whose ID is 3

get a database's User whose email is "[e-mail]"

Using Multiple Filter Conditions

You can combine multiple filter conditions using the and keyword.

Example

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

Note: This is the only procedure that supports retrieving database records with multiple column filters.

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