Data Lookup
Last updated
Last updated
Data Lookup is a that triggers the search for a from a . The search operation is carried out using criteria that include values for the unique field (or fields) of the table.
The block consists of the following (from top to bottom):
NOTE:
As the Customers database table has a single unique field CustomerID, the Criteria value parameter is linked to an object with its CustomerID property assigned to the desired search value, which is 2 in this scenario.
The result for the above example is shown in the image below.
Table: that accepts a value representing the name of the .
Dataset Name: that accepts a value representing the name of the dataset. This can be any text value and can later be used to track the completion of the read.
Criteria: that accepts an value containing the search criteria. The Object block is pre-attached by default and its properties are automatically populated based on the unique fields of the selected table.
This block initiates the database search, which will occur in the background. To track the status and to take an action upon completion of the search, use the block.
To access the record after a successful search, use the block.
NOTE: Please refer to the prerequisite information shown before seeing the example.
The image below shows an example of the Data Lookup block where a search is conducted on the Customers database table which we have discussed .
To track the completion of this search operation, we use the block. When the search completes successfully, we use the block to retrieve the FirstName and LastName fields and display that using the block.
