Describe the bug
Currently, attachments are ordered by the attachment ID (e.g. CollectionObjectAttachmentID), in ascending order. This is not configurable via the form meta menu either. This makes it so the only option to reorder attachments is to update the ID behind-the-scenes or for the user to delete and reupload an attachment.
To Reproduce
Steps to reproduce the behavior:
- Add 3 attachments
- Update the
ordinal value to change the order
- See that the ordinal is not respected
Happens in both v7.11.4 and v7.12.0.4
Expected behavior
The attachments should be organized by ordinal (as it was in Specify 6).
Screenshots
SELECT
coa.CollectionObjectAttachmentID,
coa.TimestampCreated,
coa.Ordinal,
a.origFilename
FROM collectionobjectattachment AS coa
LEFT JOIN attachment AS a
ON a.AttachmentID = coa.AttachmentID
WHERE coa.CollectionObjectID = 1062
ORDER BY coa.Ordinal;
Reported By
Fedor at NHMD on BoldDesk (#840)
Describe the bug
Currently, attachments are ordered by the attachment ID (e.g.
CollectionObjectAttachmentID), in ascending order. This is not configurable via the form meta menu either. This makes it so the only option to reorder attachments is to update the ID behind-the-scenes or for the user to delete and reupload an attachment.To Reproduce
Steps to reproduce the behavior:
ordinalvalue to change the orderHappens in both
v7.11.4andv7.12.0.4Expected behavior
The attachments should be organized by
ordinal(as it was in Specify 6).Screenshots
Reported By
Fedor at NHMD on BoldDesk (#840)