Click or drag to resize
CalculationWorks Logo
Access Path Browser Dialog

Link parameters with other columns of same table or other table using relations.

Dialog Access Path Browser

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 may 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 Steps and ends with a Column Step.

Tip Tip

Using All Rows ("*") is faster than Distinct Rows ("%").

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).

    The "%" symbol says take distinct rows only.

  • "+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.

    The "*" symbol says take all rows (not distinct rows only).

Controls

Image

Name

Description

Root Table

The table where access path starts.

Access Path

The access path.

112 Left Arrow Long Orange 16x 16 72

Remove Last Step

Removes the last step from access path.

Bcf Delete

Delete Access Path

Clears access path.

Table

Table from where the access path starts.

Column / Validator

Object that carries the function.

Parameter

Parameter name.

Current Table

Name of table after last relation step in access path.

To Parent

Relations where current table is child. Clicking a relation name will add the relation step and relations parent table will be current.

To Child

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.