Databases - Relation columns #62

New Issue

garrettmills · 2021-01-14T01:35:06Z

garrettmills commented

2021-01-14 01:35:06 +00:00

Create 3 new column types:

Manual Relation

In the config for this column, the user selects a database

Then, when editing the column, they can select one or more records from the other database which show up as icons in the cell renderer.

When clicked, the cell should open the related database pre-filtered to the selected rows. This will require a bit of work.

Automatic Relation

This is the same as the manual relation, but in the config for the column the user picks a column from the local database and the foreign database to match. All rows that match the local column value on the foreign database show up in the column.

Relation Reference

This column references a relation on a related table. It allows users to view the inverse of a relation from the related table. In the column settings, the user chooses a database, then a relation column on that database.

The cell renders the icons for the rows that are related to this one using the foreign relation's rules (manual or automatic).

Clicking opens the foreign database pre-filtered to those rows.

Aside

Add support to the Database API and the plugins classes for querying these relations.

Create 3 new column types: ## Manual Relation In the config for this column, the user selects a database Then, when editing the column, they can select one or more records from the other database which show up as icons in the cell renderer. When clicked, the cell should open the related database pre-filtered to the selected rows. This will require a bit of work. ## Automatic Relation This is the same as the manual relation, but in the config for the column the user picks a column from the local database and the foreign database to match. All rows that match the local column value on the foreign database show up in the column. ## Relation Reference This column references a relation on a related table. It allows users to view the inverse of a relation from the related table. In the column settings, the user chooses a database, then a relation column on that database. The cell renders the icons for the rows that are related to this one using the foreign relation's rules (manual or automatic). Clicking opens the foreign database pre-filtered to those rows. ## Aside Add support to the Database API and the plugins classes for querying these relations.

garrettmills added the

Out-there Idea

Feature Request

Scope: Databases

labels 2021-01-14 01:35:06 +00:00

Sign in to join this conversation.