Page tree

Versions Compared


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

Foreign keys and relationships between tables for Play SQL Spreadsheets.

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

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

jqlQueryproject = PLAYSQL AND fixVersion = 23.13.0

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

jqlQueryproject = PLAYSQL AND (affectedVersion = 23.13.0 OR affectedVersion = 23.130.x)

Widget Connector