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.