Foreign keys and relationships between tables for Play SQL Spreadsheets.
This is a highly expected feature. We are introducing relationships between tables in Play SQL 3.0.
How to create a Foreign Key?
Choose a table, and click on a column that you want to make as a Foreign key.
Click on the key icon.
|Select the targeted table.|
|Select a column from the targeted table as a display field.|
How to display another column, the original foreign key's values or remove it ?
Once a foreign key exists, you can remove the 2 parts of it:
|Remove the renderer only.|
Depress the "+" button:
|Remove the foreign key entirely.|
How to display the linked records?
Click on the "Form" tab.
It displays the rows referring to the current recording.
By clicking on the foreign keys, we can navigate from one table to another.
A path is displayed above, we can click on a breadcrumb to go backwards.
Reordering spreadsheets in the index
It is now possible to use drag-and-drop to rearrange spreadsheet positions.
- The "PSEA" plugin will be installed together with Play SQL Base or Spreadsheets. It is required. It performs the Excel exports.
- The Legacy SQL Macro was removed in a previous version. Please do not upgrade if you still require it.
- If you upgrade from Play SQL 2.6, there are new requirements:
- Requires Java 8,
- Requires PostgreSQL 9.2,
- Requires Confluence 5.10,
- Since November 2015, requires IE10 (see Atlassian Confluence's end of support announcement for IE9).
- If you upgrade from Play SQL 2.9, there are schema changes:
- You may wish to back-up your database before upgrading.
- See Release Notes 2.10 - Upgrade Guide for more information,