Versions Compared

Version Old Version 1 New Version 2
Changes made by

Volodymyr Rohach

Volodymyr Rohach

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

a. If the holdings source is anything other than FOLIO or MARC (e.g. -), then change to FOLIO.
b. If the holdings source = MARC, check to see if there is a linked SRS MARC Holdings record. If yes, then keep the Holdings source as MARC, and ensure that View source and Edit via QM works for the Inventory Holdings record. If no, then set the Holdings source as FOLIO, and ensure that View source/Edit in QM do not display in the Holdings Action menu.

...

Code Block
languagesql
titleSelect Holdings where sourceName=MARC and external_hrid NOT exists in SRS
SELECT  *
FROM    diku   ${tenant}_mod_inventory_storage.holdings_record
WHERE   
diku  ${tenant}_mod_inventory_storage.holdings_record.jsonb ->> 'sourceId' = (
SELECT 
id::text
FROM diku${tenant}_mod_inventory_storage.holdings_records_source
WHERE diku${tenant}_mod_inventory_storage.holdings_records_source.jsonb ->> 'name' = 'MARC')
AND NOT EXISTS
(SELECT  *
 FROM    diku   ${tenant}_mod_source_record_storage.records_lb
 WHERE   diku  ${tenant}_mod_source_record_storage.records_lb.external_hrid = diku${tenant}_mod_inventory_storage.holdings_record.jsonb->>'hrid');

...