TOTVS Fluig English

Árvore de páginas

Você está vendo a versão antiga da página. Ver a versão atual.

Comparar com o atual Ver Histórico da Página

« Anterior Versão 12 Próxima »

Index 


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.


Datasets

01. In the main menu, click Control Panel.

02. In the General tab, click Datasets.

03. View all internal, generated or encodeddatasets

It is possible to search for a specific dataset through the Search field located in the upper right corner of the window.



Displaying datasets

01. In the Display field located at the top left side of the screen, select the type of dataset to view.

02. Select the type of dataset to view: Encoded, Generated or Internal.

03. The selected types of datasets will be listed



New Dataset

01. Click New Dataset.

02. In the Code field, enter a code for the dataset.

03. In the Description field, enter a description for the dataset.

04. In the Service field, select a service for the dataset.

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.

05. When you select the SOAP, REST, or JDBC services, the fill-in options will appear differently from one to the other. Fill in the fields according to the selected service.

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.

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.

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.

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).

Click Save to complete the creation.


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.

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.

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).

Click Save to complete the creation.


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.

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.

06. Click Save.



Enable offline dataset on mobile

01. Click the edit icon in the Offline mobile column, represented by the pencil symbol.

02. Define the required information in the pop-up window

The default setting is No (Off).

Required information:

Use cache on mobile devices?

When enabled, the data in the dataset is stored in cache when used on mobile devices. In this case, the button ON (yes) is displayed, indicating that the feature is active. When set to disable the feature, the button OFF  (no) is displayed, indicating that the feature is disabled.

Mobile cache expiration time

Time in which the stored data is considered valid and remains in the cache of mobile devices before being updated.

Not use cache when the mobile device is online?

When enabled, the data in cache is not queried when the mobile device is online, that is, it is required from the external system.

03. Click Save

Attencion

New data created on mobile devices when using the offline mode is only available for query on other forms after the mobile application is synchronized with the fluig server. For more information about this process, go to the step Configuring dataset synchronization on this page.

For Internal datasets, this option is not editable. They are only viewed as default, Internal.



Synchronize dataset data

01. Click the edit icon, represented by the pencil symbol, located in the Synchronization column.

02.  Click On to enable it.

03. Click Synchronize now

When clicking this option, the dataset data written on the platform are synchronized with the corresponding data from the external system.

It is only possible to enable data synchronization for datasets developed on the platform. When enabling synchronization, it is carried out according to the schedule created in Task Scheduler. For information on how to define the synchronization frequency, see the alternative path Edit scheduling

04. Click Off to disable it.

05. Click Save.

06. Click Close.

This option can only be edited for Generated Datasets. Internal Datasets are viewed as default.



View synchronization information

01. Click the information icon in the Last synchronization column.

02. View the information on the last data synchronization of the dataset.

03. Click Close to go back to the main window

This option can only be edited for Generated Datasets.



Edit synchronization scheduling

01. Click the horizontal bars icon, located in the Options column.

02. Click Edit scheduling.

03. In the Scheduling settings window, change the information of your choosing

For additional information on the fields, see Task Scheduler.

04. Click Confirm.

To view the next scheduled synchronization, simply keep an eye on the Next synchronization column, which shows the exact date and time of the next synchronization.

This option can only be edited for Generated Datasets.



Display code

01. Click the horizontal bars icon, located in the Options column.

02. Click Display code.

03. View the javascript source code of the developed dataset.

04. Click Close



Delete dataset

01. Click the horizontal bars icon, located in the Options column.

02. Click Delete dataset.

03. In the pop-up message, click Delete

When clicking this option, all data contained in the dataset is deleted.

This option can only be edited for Generated Datasets



Querying dataset

01. Click Query, represented by the magnifying glass icon, located in the Options column.

02. View dataset data.

03. Click Close.



Edit dataset

01. Click Edit dataset, represented by the pencil icon, located in the Options column.

02. Make the necessary changes.

03. Click Save.

Solo los datasets del tipo Generados podrán tener esta opción editada.




Please note!

This documentation is valid from the 1.6.4 - Waterdrop. If you use a previous update, it may contain information different from what you see on your platform.



  • Sem rótulos