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.
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.
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.
New relationships can be added in the data groups dialog via Add relationship.