Explore table relations window
Explore table relations is invoked from the Object context menu.
The basic idea is simple: the selected table is opened and shown with all inbound and outbound table relations. The selected table is then "fully explored" in the 1st degree connections. However the related tables may themselves have further, yet unexplored table relations:
| # | Name | Description |
|---|---|---|
| 1 | Node (table) | Here the initial table on which the explore table relations was initiated. |
| 2 | Edge (relations) | Each edge in the graph represents that there is at least one table relation from the source table to the target table. Right-click to invoke context menu. |
| 3 | Unexplored incoming table relations |
The Item Ledger Entry table still has 22 inbound table relations to be explored.
See the node context menu below.
|
| 4 | Unexplored outgoing table relations |
The Item Ledger Entry table still has 21 outbound table relations to be explored.
See the node context menu below.
|
| 5 | Show | Choose what the nodes show: Detailed labels (on by default) adds the counts of unexplored inbound and outbound relations, Subtitle adds a line such as Table 18, and Expand all and Collapse all show or hide every table's field list. From extensions also includes fields from extensions, and Auxiliary objects adds the pages, reports, queries and xmlports that read each table. |
| 6 | Layout | Select the layout algorithm, the edge routing and the layer direction. |
| 7 | Objects | Shows or hides the objects panel, with the Included and Excluded tables. Select a single table by clicking on it in the diagram or in the Included list. You can select multiple tables by holding down the Ctrl key. To action selected objects, right-click to invoke the context menu (described below). Excluded tables can be included again from the Excluded list's context menu. |
| 8 | Save | Save the graph to a file. |
The arrows at the start of the toolbar go back and forward through the tables that were centred, and the zoom buttons zoom out, zoom in and fit the graph to the view.
Notice that nodes are draggable with the mouse. However, wait with fine-tuning layout positioning, as whenever a new table is added or removed from the diagram, it is redrawn with the selected layout algorithm.
Edge context menu
| Menu item | Description |
|---|---|
| Show Details | Runs the find usages process to find all table relations from the source table to the target table. |
Node context menu
Node context menu:
| Menu item | Description |
|---|---|
| Explore All Inbound | Adds all tables that have table relations targeting are the table on which the context menu was invoked. |
| Explore Selected (Inbound) | Like Explore all inbound, but allows you to select which tables to include. |
| Explore All Outbound | Adds all tables that have table relations to the table on which the context menu was invoked. |
| Explore Selected (Outbound) | Like Explore all outbound, but allows you to select which tables to include. |
| Explore All In/Outbound | Add all inbound and outbound tables to the diagram. |
| Navigate to Object | Navigates to the object. |
Selected node context menu
| Menu item | Description |
|---|---|
| Exclude X Selected | Here X is the number of currently selected objects. Excludes the selected objects from the diagram and adds them to the Excluded objects list. |
| Exclude X Unselected | Here X is the number of included objects that are currently not selected. Excludes the unselected objects from the diagram and adds them to the Excluded objects list. |