Find In Database

Use this step to find a value in the database. To change records in your database, use the Execute SQL step. To extract data from the selected database, use the Query Database step. To store data in the database, use the Store In Database step.

The step verifies that the table it is accessing matches the definition of the type and configuration, and produces an error if any of these do not match. A warning is also displayed while editing the Robot, as long as the database can be reached. In this case, you can right-click the step and select (Re)create Table in Database to open a SQL dialog box, which helps you update the table from Design Studio.

When in debug mode and Values are Returned or Stored is selected under Stop When, the robot that uses the Find In Database step stops only when the execution returns to the calling Basic Engine robot.

You can add this step directly from the Robot workflow or from the State pane by right-clicking a type and clicking Insert Step > Find In Database.

Properties

Database Mapping: Select a database mapping from the databases specified in the Call Robot step.
Variable: Select a variable to read the value from. This variable must be of a complex type.
Key: Select how to compute the key for the value in the database. If you select Key Defined in the Type, the attributes that are marked as Part of Database Key in the Type editor are used to compute the key. Otherwise, when you select Calculated Key, specify an expression to compute the key.
Only Override Empty Attributes: If selected, only empty fields in the selected complex variable are overwritten with data from the database. If cleared, any existing values in the complex variable are replaced. Default - unselected.
Audit Data: If selected, the Audit data fields are included with the value. For more information, see Store Data in Databases.