Provide Data - OData Service - Data Groups

In the Data Groups dialog box, the Entity Types and collections, and their relations, of the OData service are defined. Data groups from Intrexx applications are also selected. Each data group represents an Entity Type and is automatically available in the service as an OData entity collection. Relations between Entity Types are represented in OData using what are called Association Sets and Navigation Properties. You can select parent-child relationships and references between Intrexx data groups, in order to define them as Navigation Properties in the corresponding Entity Types.

Global filters

In the selection list for the data groups, a filter can be defined for each data group by clicking

Filter . This global filter will then be used on this data group for each OData request, regardless of whether a filter has been defined in the OData request. However, in the latter case, the global filter will be combined with the request filter. This allows you to ensure that at a fundamental level, only certain data records can be accessed via an OData service.

Select data groups

Any number of Intrexx data groups may be added to an OData service by using

Add data group. In the first step, the desired data group is selected from an application. A data group may only be added once per service.

Relationships

OData Associations and Navigation Properties

Relationships and references between Intrexx data groups are represented in OData as Associations and Navigation Properties. Both 1:1 and 1:n relations can be defined. Relationships with m:n cardinality can be represented with an m:n data group. Associations in OData define the relationships and their cardinality between Entity Types. Navigation Properties, on the other hand, add properties to the Entity Types, which can be used to navigate from a data record to a referenced data record without explicitly needing to add the foreign key or reference data fields to the Entity Type. The required settings for this are selected in the Relationships dialog box.

After the data groups that will be available to the service have been selected, the relationships between them can be defined.

Add Relationship

New relationships can be added in the data groups dialog via

Add relationship.