Fetch One Block
Fetch one block fetches data from the database based on specified criteria and stores it in a variable as a dictionary. It fetches only one result. If multiple instances of data are there satisfying the criteria then the first one is returned.
# How to create a Fetch One Block
- Drag "Fetch One" block under “Database Blocks” in block picker.
- Add the name of the variable in which you want to store the fetch result.
- Select the database table from which you want to fetch the result.
- Click on "Add condition" to add filtering criteria.
- Select the database table field name and enter desired value.
- Click on Save to create the block.