Data Read
Last updated
Last updated
Data Read is a that initiates a reading of from a .
The block consists of the following (from top to bottom):
NOTE:
The image below shows our first example.
Since the Input-1 parameter was set to the value Smi, the database read resulted in the records of Jane Smith and John Smith being shown.
Table: that accepts a value representing the name of the .
Query: Optional that accepts a value representing the name of the . If this is blank, the database is read without any search criteria and sorting rules.
Dataset Name: that accepts a value representing the name of the dataset. This can be any value and can later be used to track the completion of the read.
Per Page: that accepts a value containing the number of to be read. This number is preserved for subsequent usage of the and blocks when the same Dataset Name is used.
Input Criteria: Optional that accepts an value. This is required only if a database query is selected for the Query parameter above. If the query contains search criteria parameters, the pre-attached Object block automatically gets populated.
This block initiates the database read, which will occur in the background. To track the status and to take an action upon completion of the read, use the block.
To access the records after a successful read, see , , blocks.
NOTE: Please refer to the prerequisite information shown before seeing the example.
In the above example, we initiate a database read for the Customers table which we have discussed . The Data Status block is used to track the status, and here we use the same Customers table and the dataset name of ds1. Upon success, we invoke the function Usage Example. We will look at some sample implementations for the Usage Example function.
The above sample implementations are discussed in more detail and .
Now let's take a look at another example, this time we will use the NameMatch query that is defined for the Customers table and is discussed .
The optional Input Criteria parameter is attached to the Object block, which has one property Input-1 with a value of Smi. Remember that the accepts one input parameter and will list records where either the FirstName or the LastName fields contains the given input.
Also note the sample records contained in the Customers database table provided .
The result for the above example can be seen in the , and a sample is shown below:
