...
| Índice |
|---|
| outline | true |
|---|
| exclude | .*ndice |
|---|
| style | none |
|---|
|
Speaking of datasets...
This feature allows creating datasets and defining which ones will be offline on mobile devices, which ones should be synchronized with the external data provider, and the synchronization frequency, among other options.
Datasets are components that allow standardizing access to information from locations external to the platform, such as applications and databases. High-performance datasets have a data storage cache obtained externally, which aims to reduce the number of accesses to external data services, that is, it creates a copy of the data structure within the platform for query, enhancing the performance of the datasets developed on the platform. Therefore, the data is queried on the platform itself, preventing access to data in the external provider system in every request.
In order to update the data of the copy created on the platform, go to Task scheduler and define the synchronization frequency.
This feature allows creating datasets and defining which ones will be offline on mobile devices, which ones should be synchronized with the external data provider, and the synchronization frequency, disable those that are no longer used, among other options.
Active datasets are highlighted with a stronger font color to stand out among datasets that are no longer being used.
| Informações |
|---|
| title | Stay tuned for more info! |
|---|
|
Refer to the technical documentation to learn more about dataset development. |
Datasets
...
01. In the main menu, click Control Panel.02. In the General tab, , then check Development container and click Datasets.
0302. View all internal, generated or encodeddatasets View all datasets shown in the list.
| Painel |
|---|
It is possible to search for a specific dataset through the Search field located in on the upper right corner of the window, or use the Filter button to select datasets that will be returned. |
Displaying datasets
...
01. In Click the Display field Filter button located at the top left side of the screen, select the type of dataset to viewon the upper right corner of the window.
02. Select the type of dataset to view: Encoded, Generated or Internal.03. datasets to be shown on screen. Filter by status (active, inactive and/or under editing) and type (internal, simple and/or advanced).
| Painel |
|---|
The selected types of datasets will be listed. |
New
...
simple dataset
...
01. Click New Dataset, and click Simple.
02. In the Code field, enter a code for the dataset.
| Painel |
|---|
To avoid inconsistencies, the dataset code and description must not contain special characters (except for “_” and “-”). |
03. In the Description field, enter a description for the dataset.
04. In the Service field, select a service for the dataset.
| Painel |
|---|
You can register a new Dataset from REST services. For this, it is enough to have services of this type already registered. |
|---|
If you do not have any registered services, simply go to the Services menu in the General tab of the Control Panel to create a new one. |
...
| Painel |
|---|
| Deck of Cards |
|---|
| | Card |
|---|
| When selecting the SOAP service type, complete the following fields: Operation
Selecting the magnifying glass icon will allow you to select one of the available operations. The operations will be listed by Name and PortType (ColleagueService). To set up
In the settings of the selected operation, Properties, SOAP Headers and Return Processing can be configured. | Painel |
|---|
Properties - Basic Authentication - Select whether or not to authenticate. You can define a user name and password.
- SSL - enable when soap service requires use of ssl.
- Disable Chunking - disable sending the entire soap envelope.
- List SOAP messages - enable to show the sending and receiving messages in the log.List SOAP messages - enable to show the sending and receiving messages in the log
Dataset keys
Allows setting the keys to be used during offline synchronization, in order to avoid duplicate records from each synchronization. SOAP Headers Allows you to add a header. Treatment Return - Extract Result: Allows you to select this option to extract a report in xml format and include a tag.
|
Parameters:
Fill in the parameters as required: Assignment
-Null or Variable (When Null is selected, the Value field is automatically dispensed). Value
-WKCompany or WKUser (Will be displayed when the assignment field is selected as Variable). |
| Card |
|---|
| When selecting the REST service type, complete the following fields: Operation
Selecting the magnifying glass icon will allow you to select one of the available operations. The operations will be listed by Name, Method (GET), and API. To set up
In the settings of the selected operation, the Properties, Headers and Return. | Painel |
|---|
Properties - SSL - enable when soap service requires use of ssl.
- List messages - enable to show the sending and receiving messages in the log.
- Response time - enable to display the time the request waits for the response.
Dataset keys Allows setting the keys to be used during offline synchronization, in order to avoid duplicate records from each synchronization.
Headers
Allows you to add a header. Treatment Return - Extract Result: Allows you to select this option to extract a report in JSON format and include a path
Click Save to complete the configuration. |
Parameters:
Fill in the parameters as required: Assignment
-Null or Variable (When Null is selected, the Value field is automatically dispensed). Value
-WKCompany or WKUser (Will be displayed when the assignment field is selected as Variable). |
| Card |
|---|
| When selecting the JDBC service type, complete the following fields: Table
Selecting the magnifying glass icon will allow you to select one of the available tables. The operations will be listed by Name and Type (Table, VIew or Synonym). To set up
In the selected table settings, you can configure some properties such as:
- Limit Result - Enable to limit the number of records returned.
- Key field for the table - Allows to select a key field for the table, being: limit or offset.
Click Save to complete the creation. Fields
Fill in the fields as requested:
Filters - Allows you to add filters to the fields. | Painel |
|---|
To create filters, you need to configure some information. Are they: Operation
Lets you select one of the available operations: AND, OR or NOT.
Initial value
Set an initial value. Ex: 1 Final value
Define an end value. Ex: 3 Use Like
Search for content, not exact, but that contains part of the value informed. Just select Yes or No. |
- Return - Allow or not to return a value. Just press Yes or No.
- Sort - allows you to sort the fields in ascending or descending order.
|
|
|
...