External data group - General properties
Applications module
External data group
Properties
Standard external data group
Static title / Title from constants
All information regarding this topic can be found
here.
Database connection
The desired
connection
can be selected here.
Data handler
The desired data handler for the connection can be selected here.
Table / View
You can enter the name of the
Table or
View
directly or find it by using the
Search.
Owner of the data set
In the list
Owner of the data set, a data field
that contains the ID of the owner of the data set can be selected.
Exchange external data group
Title
Enter a name for the external data group here.
More information about this topic can be found
here.
Database connection
The desired
connection
can be selected here.
Data handler
The desired data handler for the connection can be selected here.
Table / View
You can enter the name of the table or view directly here.
Search
Opens a
dialog
where you can search for tables and views.
Owner of the data set
In this list, a data field
that contains the ID of the owner of the data set can be selected.
Login as current user
With this option, the
currently logged-in user will be used for accessing Exchange.
Login as static user
With this option, Exchange users, which have already been created and had
Intrexx users assigned to them, can be selected from the Exchange
data source configuration. The user data is then shown in the lower
area of the dialog.
Select user
Opens a
dialog
where the static user can be selected.
OData external data group
Title
Enter a name for the external data group here.
More information about this topic can be found
here.
Database connection
The desired
connection
can be selected here.
Data handler
The desired data handler for the connection can be selected here.
Table / View
You can enter the name of the table or view directly here.
Search
Opens a
dialog
where you can search for tables and views.
Owner of the data set
In this list, a data field
that contains the ID of the owner of the data set can be selected.
Login as current user
With this option, the login details of the currently logged-in portal user will
be retrieved when the page, where the OData connection is integrated, is loaded.
Login as static user
With this option, OData/SAP Gateway users, which have already been created and had
Intrexx users assigned to them, can be selected from the OData/SAP Gateway
data source configuration. The user data is then shown in the lower
area of the dialog.
Select user
Opens a
dialog
where the static user can be selected.
1:n relationships
1:n relationships between OData data groups are represented
with parent data groups (e.g. Flights) and subordinate child data
groups (e.g. Bookings) in Intrexx. If you establish the database
connection in the properties of the child data group, and select the
corresponding OData Collection (Table), then the potential 1:n
relationships will be made available for selection.
In the next step, the data fields for the child data group can be
selected. It will then be possible to display dependent records from
child data sets in view tables on view and edit pages from the parent
data groups.
m:n relationships
The Velocity callable "ODataLinksCallable" can be used to
create and remove m:n relationships between two OData external data groups.
Creating an m:n relationship
$ODataLinksCallable.createLink(<Configuration GUID>, <Service GUID>, <Impersonation GUID>, <Source DG GUID>, <Source_Record_ID>, <Target Navigation Property>, <Target DG GUID>, <Target_Record_ID>)
Removing an m:n relationship
$ODataLinksCallable.deleteLink(<Configuration GUID>, <Service GUID>, <Impersonation GUID>, <Source DG GUID>, <Source_Record_ID>, <Target Navigation Property>, <Target DG GUID>, <Target_Record_ID>)
The following parameters are required:
- Configuration GUID:
The GUID of the OData configuration
- Service GUID:
The GUID of the OData Service
- Impersonation GUID:
The GUID of an impersonation user, or “null” for the current user
- Source DG GUID:
The GUID of the source data group
- Source Record ID:
The ID of the source data record
- Target Navigation Property:
The name of the OData Navigation Property which defines the relationship
- Target DG GUID:
The GUID of the target data group
- Target Record ID:
The ID of the target data record
Microsoft Office 365 external data group
Title
Enter a name for the external data group here.
More information about this topic can be found
here.
Database connection
The desired
connection
can be selected here.
Data handler
The corresponding data handler is entered automatically as soon as you select
the database connection.
Table / View
You can enter the name of the table or view directly here.
Search
Opens a
dialog
where you can search for tables and views.
Owner of the data set
In this list, a data field
that contains the ID of the owner of the data set can be selected.
MS Office365 folder
Folder
Select the desired folder.
When a folder is selected here, its data is automatically entered as
expert settings.