Add a CTE version of the 'Root relationship' plugin

Created on 5 January 2024, over 1 year ago

Updated 29 January 2024, about 1 year ago

Problem/Motivation

In the 3.x series there was a views relationship plugin that let you join to the root of the tree for a given entity.
In the 5.x this has been removed

Steps to reproduce

Install a 3.x site
Make some views that use the root relationship plugin
Update to 5.x
See the broken/missing handlers

Proposed resolution

Try to write a CTE powered version of the join to root.
Some of the work in the sort plugin might be of inspiration - it will likely require a new class that implements SelectInterface like for TreeOrder
Try to update views configuration in an update hook to rewrite the field/table names in views config from the old relationship tables/fields to the new tables/fields

Remaining tasks

User interface changes

API changes

Data model changes

📌 Task

Status

Fixed

Version

5.0

Component

Code (module)

Created by

🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10

Live updates comments and jobs are added and updated live.

Merge Requests

!28Add a CTE version of the 'Root relationship' plugin
Merged
🇦🇺Australia larowlan
updated about 1 year ago

Comments & Activities

Issue created by @larowlan
Assigned to larowlan
Comment about 1 year ago →
🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10
Merge request !28Resolve #3412450 "Add a cte" → (Merged) created by larowlan
Open on Drupal.org →
Core: 10.2.1 + Environment: PHP 8.1 & MySQL 8
last update about 1 year ago
Waiting for branch to pass

Comment about 1 year ago →

System Message

larowlan → committed f4c86844 on 5.x

Issue #3412450 by larowlan: Add a CTE version of the 'Root relationship...

Status changed to Fixed about 1 year ago2:18am 15 January 2024
Comment about 1 year ago →
🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10
Comment about 1 year ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024