Data Groups

Data groups represent a database table. To open the Properties dialog box for a data group, double-click the data group in the application structure.

The data fields of a data group can be displayed via the main menu option "Edit / Show Data Fields" when the data group is selected in the application structure.

Using the "New" option in the main menu, you can create input pages, view pages, view pages with elements, subordinate data groups, data fields, and references when a data group is selected.

Using the "Edit / Delete" option in the main menu, you can delete a data group along with all the pages, data fields, and references it contains.

Intrexx Data Groups

Intrexx data groups are the data groups that are already available when you create an application, and you can also create additional ones by selecting an application node and using the "New / Data Group" option in the main menu.

Features - General

Title

You can change the title of the data group here. You can find information about multilingual titles here.

Name of the data group

You can change the name of the data group here.

Generate a Name from a Title

Uses the title as the data group name.

Primary Key Data Type

When you create a new data group, you can choose between the "Integer" and "GUID" options.

The "Integer" option creates the primary key data field with the "Integer" data type, which is the default setting.

The "GUID" option creates the primary key data field with the "String" data type. A GUID is then automatically generated for each record and stored in the data field. Both options are available only when editing a new data group for the first time. If you switch to a different tab in the Properties dialog box, the settings will no longer be accessible.

Owner of the data field

Here, you can select a data field that contains the ID of a record's owner.

Client Filtering

No client filtering

With this option, the data in the data group is not filtered by client.

Enable client filtering for the following field

With this option, a record is displayed in the browser only if the value of the data field selected here is included in the clients to which the user is assigned. If the field is empty, the record is displayed to all users.

Enable client filtering for values from the child data group

With this option, a record is displayed in the browser only if the value of the data field selected here from a subordinate data group is included in the user's selected client. If there is no child record, the record is displayed for all users.

Create a New Child Data Group

Creates a child data group containing the relevant system data fields and an ID field for the ID of the stored value.

The values in the primary key and foreign key are automatically generated when records are created in the browser. The value of the primary key corresponds to the ID of a child record, while the value of the foreign key corresponds to the ID of the associated parent record. The stored value is determined from the data source.

Clicking the small arrow icon to the right of the " " button opens a menu that allows you to select the type of primary key for the new child data group ("Integer as Primary Key" or "GUID as Primary Key").

Create a New Data Field

Opens a dialog box where you can create a data field.

More Information

Multi-Tenancy

MS365 Data Group

You can link Intrexx records to Microsoft 365 files.

To do this, create an "MS365 data group." It (automatically) contains an "MS365 File" data field. When creating an "MS365 Data Group," Intrexx opens a properties dialog that prompts you to enter all the necessary information for connecting to Microsoft 365.

You can find detailed information on this in the following sections:

• Create a Microsoft 365 data group

• Add an MS365 file field

System Data Group (System Data Group)

Only a single record can be stored in a system data group.

This makes the system data group suitable for storing constants that apply across the entire application, such as a fixed investment amount above which approval is required.

For each application, you can create only one system data group at a time by selecting the application node and choosing "New / System Data Group" from the main or context menu.

Features - General

Enter the title of the system data group here. You can find information about multilingual titles here.

The data in the system data group can be used in all data groups within the application. The values of a system data group are stored in the LCAPPPROPS database table under the application GUID.

With an input page integrated into the application menu, the data in the system data group can be edited very easily.

External Data Groups

An external data group is used to integrate data from external sources. You can find all the information here.

Subordinate data groups

If you select an existing data group in the application structure, you can use the "New / Data Group" option in the main menu to create a subordinate data group.

Subordinate data groups can be used to represent so-called parent-child relationships. In practice, these data relationships are used when master data in the parent data group is linked to multiple records in a child data group (e.g., product groups that can contain multiple items).

Intrexx lets you create such links with a single mouse click, without any programming. In the browser, when you navigate from a parent record (e.g., from a view table ) to a page in the child data group, the reference is established automatically.