SQL queries in BitstreamDAOImpl finders do not respect bitstream_order

[saschaszott]

Problem Description

The SQL queries in the find methods of BitstreamDAOImpl currently do not take the bitstream_order attribute into account when retrieving bitstreams for a given bundle. As a result, the order of bitstreams returned does not match the order shown in the file administration UI.

The SQL queries should be updated to include an ORDER BY bitstream_order clause to ensure consistency between the database retrieval order and the UI display order.

[saschaszott]

The method findShowableByItem does not exist in vanilla DSpace. Why does DSpace CRIS depend on this method?

[saschaszott]

The current implementation in DSpace CRIS 2024.02.02 uses the internal row ID (Postgres: ctid) to sort the bitstreams within a bundle. This can differ from the sorting based on bitstream_order.

[saschaszott]

Bugfix provided in PR #515