loadData
Description
Loads the data from a local table, staging database or 3rd party connector.
Input / Parameter
Name | Description | Input Type | Default | Options | Required |
---|---|---|---|---|---|
dataset | The name of the local table to load data from. | String/Text | - | - | Yes |
limit | The number of records to be returned from the local table. | Number | - | - | No |
page | The page number. | Number | - | - | No |
filter | The filters for the fields and values to retrieve. | Array/List | - | - | Yes |
orFilter | Additional filters for the fields and values to retrieve. | Array/List | - | - | No |
order | Sorts the data with the provided details. | Array/List | - | - | No |
extra | Extra parameters stored and passed to callback. | Any | - | - | No |
Output
Description | Output Type |
---|---|
Returns the list of records that is loaded. | Array/List |
Callback?
callback
The function to be executed if the records are loaded successfully.
errorCallback
The function to be executed if the records are not loaded successfully.
Video
Coming Soon.
Example
The user wants to load the data from dataset "l_customer".
Step
Create a button, pannel, datalist and label from component.
( Set the dataset name "l_customer" for column Dataset. We assumed the dataset name have been created when you create local table in Services. )
( When you click the each label, set the field name to "code" "id" and "name" respectively for field column. )
Call the function "dataFromString" and define the dataset and string. dataset: l_customer string: [{"id":"1","code":"C20000","name":"Maxi-Teq","address":"300 Billings Drive","tel":"555-0110","term":"C.O.D"},{"id":"2","code":"C23900","name":"Parameter Technology","address":"908 Darby Road","tel":"555-0119","term":"C.O.D"}
Call the function "loadData"and define the dataset and limit. dataset: l_customer limit: 20
Result
![](https://docs.emobiq.com/~gitbook/image?url=https%3A%2F%2F399701567-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FwmJ1RKjM2uNFaL6fO3Xu%252Fuploads%252Fgit-blob-9321e3c138959019ef0c44621d3ce3dda3e2f80b%252FloadData-result-1.png%3Falt%3Dmedia&width=768&dpr=4&quality=100&sign=ce89ff14&sv=1)
( When you call the function "dataFromString", and put a string in json format.The outcome was shown in image above. )
( When you call the function "loadData", and set the limit is 20, therefore it will display the data from id 1-20 instead of until id 24. )
Links
Last updated