Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
SEO Metadata

Foreign keys and relationships between tables for Play SQL Spreadsheets.

Info
titleHighlight of the release
  • Foreign keys and relationships between tables

Foreign Keys

This is a highly expected feature. We are introducing relationships between tables in Play SQL 3.0.

Widget Connector
urlhttp://youtube.com/watch?v=yg-dH0iqpoI


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:

ActionEffectMethod
Remove the renderer only.
  • The cell will be displayed as a normal "integer" field.
  • The data in the database won't be modified,
  • The foreign key constrain will remain, users have
    to enter valid integers matching IDs in the target table.

Depress the "+" button:

Image Modified

Remove the foreign key entirely.
  • The cell will be displayed as an integer,
  • The user will be free to enter any value,
  • The data in the database won't change, but the FK constraint
    will be removed.

Image Modified

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.

Issue list

Jira
serverJIRA
columnskey,summary,type,status,resolution,components
maximumIssues20
jqlQueryproject = PLAYSQL AND fixVersion = 23.13.0
serverIdc44f7f6b-309d-3e24-ae45-f50de66a98eb

Upgrade notes

  • 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:
  • If you upgrade from Play SQL 2.9, there are schema changes:

Known issues

Jira
serverJIRA
columnskey,summary,type,status,resolution
maximumIssues20
jqlQueryproject = PLAYSQL AND (affectedVersion = 23.13.0 OR affectedVersion = 23.130.x)
serverIdc44f7f6b-309d-3e24-ae45-f50de66a98eb

Widget Connector
urlhttps://twitter.com/settings/widgets/464752656255184898/edit