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

  1. Drag "Fetch One" block under “Database Blocks” in block picker.
  2. Add the name of the variable in which you want to store the fetch result.
  3. Select the database table from which you want to fetch the result.
  4. Click on "Add condition" to add filtering criteria.
  5. Select the database table field name and enter desired value.
  6. Click on Save to create the block.