Issue | Reported Date | Temporary/Workaround Solution | Expected Permanent Solution |
---|---|---|---|
In the public.srs_records table, the column external_id is actually the instance_id | None needed | Currently not known | |
In the public.srs_marctab table, all ids are in uuid format, and this does not match the format of ids in other tables | Cast all ids from tables that connect to srs.marctab as ::uuid Example code when joining srs.marctab AS sm to rsr.records AS sr LEFT JOIN srs_marctab AS sm ON sr.id::uuid = sm.srs_id | None | |
In the public.srs_marctab table, the instance_id column is incorrect and should not be used. | 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 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 --NOTE that all ids in the srs.marctab table have been cast as uuids, so cast the OTHER table's id as ::uuid
| Currently not known | |
public.audit_circulation_logs did not |
...
start recording loan renewals until December 17, 2021. |
| The circulation_loans table has a record of renewals starting 7/1/2021, but note that these are only for items checked out since 7/1/2021. | None |
public.note table does not contain any data, and will impact any queries using this table | Currently not known | ||