Find Join Path
find_join_pathFinds the shortest accepted relationship path between two terms or tables, returning ON conditions, a ready-to-use FROM/JOIN clause, fan-out warnings, and alternative role options.
Instructions
Shortest chain of accepted relationships between two Terms or tables, with ON conditions, a ready FROM/JOIN clause, fan-out warnings and alternative roles (e.g. billing vs delivery city).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | Yes | Term or table to start from. | |
| target | Yes | Term or table to reach. | |
| datasource | No | Datasource name. Optional when only one datasource is registered. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||