2.2.2. Table Publishing

Published Tables

The fields in this window are presented below:

• Tenant: mandatory - the tenant that publishes the data;

• Organization: mandatory - the tables can only be published with the "*" organization;

• Table: mandatory - the table you wish to publish (accessible for external applications);

• Publishing Name: mandatory - the name it will be referred to by external applications. A table in AD can be published multiple times using different publishing names;

• Publishing Type: mandatory - the publishing type:

  • In: the data will only be published in entry situations (data acquisition/modification);

  • Out: the data will only be published in exit situations (data interrogation by external applications)

  • Both: both for In and for Out.

• Sql WHERE: optional - 'where' data selection condition. Only works for 'Out'. Can contain dynamic parameters identified by the '?' sign;

• Sql ORDER BY: optional - the order of the selected data. Only works for 'Out';

• Resolve ID Values: optional - Only works for 'Out' and specifies if the ID-type columns are automatically solved based on the application dictionary or not. The solving means that the numerical values (IDs) are converted into information that can be interpreted by the users based on the Identifier columns belonging to the base table for the ID column;

• Active: optional - this checkbox indicates if the publishing is active or not. Inactive publishings cannot be used by external applications;

• Get Columns: optional - this will fill in the column list with the columns of the table in the application dictionary. If the publishing involves the 'In' publishing type, the columns marked in the AD as mandatory will automatically be added to the published columns list. If the publishing is of 'Out' type, no column will be included, by default, in the list of published columns;

• Generate Template File: optional - this generates a template XML file used for the data transmission to SocrateCloud (IN).

Role Access

Here you can specify the roles that can access this publication. Only the roles which have been granted access in the Role Access tab of the Web Services window will appear in the list.

Note: If you do not enter any role in this tab, then the system will consider that ALL the roles defined in the Role Access tab of the Web Services window should be granted access to this publication!

Column Sequence

In this tab you can specify both the columns to be published (those from the right side) and their publication order.

Published Columns

In this tab you can specify certain properties for the published columns.

'Where' parameters

In this tab you can specify the dynamic parameters type used in the SQL Where condition for the table. Their order, which is given by the Sequence field, must follow the order they appear in the SQL Where condition.