Specify 7 Version: issue-609
Git SHA: e1e47642f98ffc3e7e54c6cba50f79c3d38f9b2e
I had the great fortune today of encountering 2 bugs in one go while trying to add a bunch of CO records to an accession earlier. Both very frustrating: the first essentially completely blocks us from using an entire table until it’s fixed.
Bug 1: Adding CO records that share an attachmentID to an Accession triggers an “out of date” crash preventing a save.
Description: Adding CO records to an Accession using the Interactions Search Dialog (QB, Record Set, or simple search) works for any number of CO records as long as no 2 CO records in the set share an attachmentID (CO->COAttachment->AttachmentID). I’ve confirmed that this error does not affect these COs in Loan Interactions (I think this is because the Loan Interaction Search Dialog uses CatNos to create a list of preps, which don’t have duplicated AttachmentIDs), but it probably affects any interaction that has a direct relationship to the CO table. This issue persists whether CO records are added via the Accession form, or added manually from the CO records themselves by Accession QCBX.
This may be a somewhat unique bug in that most collections do not have duplicate attachmentIDs for COs, but we do (this was done for our collection during the conversion, I requested a to-many relationship between attachment and CO because it saved 2500% in attachment server space over the alternative: uploading the same ledger image attachments 25 times, once per CO.)
To reproduce:
- Make an Accession record.
- Add any two COs with the same AttachmentID, either at the same time, or sequentially.
- Click save.
Specify 7 Crash Report - 2025-07-02T19_09_17.794Z.txt (815.9 KB)
Bug 2: Search Dialog “Record Sets” button does not display a complete set of Record Sets, only 10 apparently random ones
Description: When clicking “Record Sets” in the Accession Interaction Search Dialog window (and possibly in other Search Dialogs), the user is shown a list of 10 random Record Sets, notably not the entire set of record sets for that user. It is unclear how the list is assembled (it isn’t ascending by date, nor is it organized by recordset ID).
To Reproduce:
- Open any Accession record as a user with more than 10 record sets saved
- Open search dialog with magnifying glass on CO subform
- Click “Record Sets” and see that not all record sets appear.