Issue | Reported Date | Temporary/Workaround Solution | Solution Status and Date |
---|---|---|---|
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 srs_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
| Fixed, the instance_id column from srs.marctab has been corrected as of 9/12/22. | |
public.audit_circulation_logs did not start recording loan renewals until December 17, 2021. |
| The circulation_loans table has a record of renewals (renewal count) starting 7/1/2021, but note that these are only for items checked out since 7/1/2021. | None |
public.notes table does not contain any data, and will impact any queries using this table | None | Upgrade 1.7.1 will solve this issue (update date to be determined) | |