LDP Known Issues

Cast all ids from tables that connect to srs_marctab as "::uuid"

Example code when joining srs_marctab AS sm to srs_records AS sr

        LEFT JOIN srs_marctab AS sm ON sr.id::uuid = sm.srs_id 

The srs_marctab table can be connected to the public.inventory_instances table via hrid, and the instance_id can be brought in from the inventory_instances table.

Example code:

SELECT
    ii.id AS instance_id,
    ii.title AS title,
    substring(sm."content", 7, 2) AS "format_type"
FROM 
    public.inventory_instances AS ii
LEFT JOIN srs_marctab AS sm
    ON sm.instance_hrid =ii.hrid

WHERE sm.field = '000'

Another way to get data from the srs_marctab table and insert a correct instance_id is via the srs_records table.

Example code:

SELECT
        sr.external_id AS instance_id,    
        substring (sm.content,7,2) AS format_code
FROM
        srs_records AS sr
        LEFT JOIN srs_marctab AS sm ON sr.id::uuid = sm.srs_id 
 WHERE sm.field = '000'     

  --NOTE that all ids in the srs_marctab table have been cast as uuids, so cast the OTHER table's id as ::uuid