Backfill RelatedWorkItems (automatically)
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
While we can ensure that every related_epic_link has a work_item_links, we don't ensure this the other way around.
So when Relate quick actions doesn't sync back to legac... (#515885 - closed) we introduced a bug in the REST API only. While making the related-work-item links the SSoT is part of the solution - we still need to keep the IDs consistent in the REST API.
Until we figured out how to best approach this with #519265 we might want to automatically backfill data on the legacy tables when we figure out it's missing.
So we'd have
- WorkItem tables to be the source of truth
- LEFT JOIN the legacy tables
- When records are missing, we create them
Edited by 🤖 GitLab Bot 🤖