diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-12 16:13:26 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-12 16:13:26 +0100 |
| commit | 924893d051920a93553a16b148efb33d1691285c (patch) | |
| tree | bf77b35da4e45584cc5c99b9171b63b82ce9088a | |
| parent | 96fa98e388aaca189de0134bb8d1c8374bb75b91 (diff) | |
| download | liberty-924893d051920a93553a16b148efb33d1691285c.tar.gz liberty-924893d051920a93553a16b148efb33d1691285c.tar.bz2 liberty-924893d051920a93553a16b148efb33d1691285c.zip | |
loadContent: add linked_data alongside linked_title from lc_linked JOIN
Exposes liberty_content.data of the linked content item so BOM and other
xref view templates can display description without a separate enrichment query.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
| -rw-r--r-- | includes/classes/LibertyXrefType.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/includes/classes/LibertyXrefType.php b/includes/classes/LibertyXrefType.php index 89b1419..8fc4d3c 100644 --- a/includes/classes/LibertyXrefType.php +++ b/includes/classes/LibertyXrefType.php @@ -255,7 +255,8 @@ class LibertyXrefType { CASE WHEN x.`end_date` IS NOT NULL AND x.`end_date` < ? THEN 'history' ELSE s.`x_group` END AS type_source, pc.`add1` || ',' || pc.`add2` || ',' || pc.`add4` || ',' || pc.`town` AS address, - lc_linked.`title` AS linked_title + lc_linked.`title` AS linked_title, + lc_linked.`data` AS linked_data FROM `".BIT_DB_PREFIX."liberty_xref` x JOIN `".BIT_DB_PREFIX."liberty_xref_item` s ON s.`item` = x.`item` |