Link Search Menu Expand Document

Where Clauses

Category: Table

When you want to select, update, or delete rows in a table, you can provide a where clause to limit the rows affected.

Here are a few samples:

Sample Description
id == [$variable$] Where the row’s ID equals the variable provided
username == "[$variable$]" Where the row’s username equals the variable provided
firstName == "[$variable1$]" AND lastName == "[$variable2$]" Where the row’s first name and last name match the variables provided
timestamp > [$variable$] Where the row’s timestamp is greater than the variable provided

Sample Workflows

The following sample workflows are available in our repository’s workflows folder to help you get familiar with this concept. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.