![]() | |
Access Path Browser Dialog |
Link parameters with other columns of same table or other table using relations.
Parameters can be linked with cells in the same row or with cells in other rows using relations. So a computed cell knows where to get parameter values when calculating. On the other hand, each cell knows whitch computed cells have to be recomputed when updating its value. Between the computed cell and the source cell my be relation steps. The link specification is called Access Path. Access Path always starts at the computed cell then it may go to other rows via Relation Stepsand ends with a Column Step.
Access Path Examples:
"Column42"
Parameter will take its input from same row in column "Column42"
"-RelationMaster2Detail.Name"
To obtain input parameter takes parent row via relation named "RelationMaster2Detail". There it will take its input from parent row and column "Name"
The "-" symbol indicates the relation will be passed from child to parent (from many to one).
"+RelationMaster2Detail.Price"
To obtain input parameter takes child rows via relation named "RelationMaster2Detail". There it will take its input from child rows and column "Price"
The "+" symbol indicates the relation will be passed from parent to child (from one to many). In case of any "to many" access in access path, the parameter value will be an array with one dimension.
Image | Name | Description |
---|---|---|
Root Table | The table where access path starts. | |
Access Path | The access path. | |
![]() | Remove Last Step | Removes the last step from access path. |
![]() | Delete Access Path | Clears access path. |
Current Table | Name of table after last relation step in access path. | |
To One | Relations where current table is child. Clicking a relation name will add the relation step and relations parent table will be current. | |
To Many | Relations where current table is parent. Clicking a relation name will add the relation step and relations child table will be current. | |
Columns | Column names of current table. Clicking a name will add the final column step to access path and close the dialog. | |
Filter | Column name filter. | |
Filter Types | Filters columns on expected type. |