While development and customization of AX forms we often need to add multiple datasources on the form. But there is only one main data source on the form. Remaining are joined to the main or any of its dependent data sources.
For adding multiple data sources we need to set following properties:
Join Source: The data source to which chile (current) data source will be connected.
Link Type: Link type will specify the type of link that will be established with parent datasource.
Link type has following options:
Active: Active link type update the child data source without any delay when you select the master table record. This has performance problems when dealing with multiple records.
Delay: It is same as Active link type except it doesn't update the child data source immediately, it updates the child datasource when child table record is selected or set focus.
Passive: If this property is used as link type then the child datasource will not update automatically. You need to update child datasource manually in code by calling its executeQuery() method.
Inner Join: Inner join shows the data of child data source that matches the parent data source. Its like join of SQL.
Outer Join: It will return all parent records and matched child records.
Exists Join: It works like inner join but the difference is it only returns parent table records not the child table records.
Not Exist Join: It works completely opposite to Exists Join. Returns only those rows of parent table which are not matched with child table.
Hope it helps !!!
 |
| Form data source |
For adding multiple data sources we need to set following properties:
Join Source: The data source to which chile (current) data source will be connected.
Link Type: Link type will specify the type of link that will be established with parent datasource.
Link type has following options:
Active: Active link type update the child data source without any delay when you select the master table record. This has performance problems when dealing with multiple records.
Delay: It is same as Active link type except it doesn't update the child data source immediately, it updates the child datasource when child table record is selected or set focus.
Passive: If this property is used as link type then the child datasource will not update automatically. You need to update child datasource manually in code by calling its executeQuery() method.
Inner Join: Inner join shows the data of child data source that matches the parent data source. Its like join of SQL.
Outer Join: It will return all parent records and matched child records.
Exists Join: It works like inner join but the difference is it only returns parent table records not the child table records.
Not Exist Join: It works completely opposite to Exists Join. Returns only those rows of parent table which are not matched with child table.
Hope it helps !!!
No comments:
Post a Comment