*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Further, if you want to display the subject heading as it appears in the bibliographic record, you may use a STRING_AGG FUNCTION to format the content rows as a subject heading string. Here is an example using instance HRIDs between 6403921 and 6404000:with
WITH lc as
(
...
SELECT DISTINCT
sm.instance_hrid,
...
sm.field,
sm.content
...
FROM srs_marctab sm
...
WHERE sm.instance_hrid between '6403921' and '6404000'
...
AND sm.field like '6%%'
...
AND sm.sf in ('a','x','y','z')
...
AND sm.ind2 = '0'
...
AND sm.ord = '1'
)
...
SELECT
...
lc.instance_hrid,
...
lc.field,
string_agg (lc.content, ' -- ') as lc_subject
...
FROM lc
...
GROUP BY
...
lc.instance_hrid,
...
lc.field
...
;
;
And the results would be:
