Composed primary key use wrong base_field for relationship

Created on 31 January 2024, 10 months ago
Updated 26 February 2024, 9 months ago

Problem/Motivation

I need a view using a relation on a target table having composed primary key (actually locales_target with lid and language has primary key) .
When creating the view the relationship is using the last column composed the primary key, these make the relashionship failed

Steps to reproduce

Create custom Table on locales_source and locales_target
Create relashionship from locales_source to locales_target
Create a view on locales_source using the relation

The Join is using locales_target.language as relashionship

Proposed resolution

Use the first Primary key found in the table structure (lid)

Remaining tasks

Make the relationship field custimisable in the relationship configuration form

🐛 Bug report
Status

Fixed

Version

2.0

Component

Views

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024