[Task] Sub-Issue 1: Establish a default sorting order between sample, measurement and raw data entities

[Steffengreiner]

What's the issue?

Context
Currently, the sample, measurement, and raw data grids in the UI and the exported sheets have no consistent default sort order.
This causes rows to be misaligned when users copy or compare data across sheets, making cross-referencing error-prone.

Current Behaviour
The following UI elements and exported files have no meaningful default sort order:

• The sample grid
• The measurement grid for both proteomics and genomics
• The raw data grid
• Downloaded sample and measurement edit templates
• Downloaded sample and measurement export sheets
• Downloaded URL List for raw data download

Expected Behaviour
All grids and their corresponding downloaded sheets share a consistent user understandable default sorting order.

Examples include either:
1.) Ascending by their respective ID (sample ID for samples, measurement ID for measurements and raw data).
2.) FIFO Principle (Store the row numbers for each of the user provided filled-in templates and sort by this row number)

Acceptance Criteria

• The default sorting is consistent between the raw data grid, the measurement grid and the sample grid .
• The default sorting is consistent between the exported sample and measurement exports and edit template and in accordance with the downloaded URL List from the raw data grid.
• The default sorting is consistent between aforementioned grid elements and the exported files.
• Given the sample grid is loaded, when no custom sort has been applied by the user, then rows are sorted lexicographically ascending by sample ID or FIFO.
• Given the measurement grid is loaded, when no custom sort has been applied by the user, then rows are sorted lexicographically ascending by measurement ID or FIFO
• Given the raw data grid is loaded, when no custom sort has been applied, then rows are sorted lexicographically ascending by the measurement ID or FIFO
• Given a user downloads the edit metadata sheet for samples or measurements then rows in the sheet are sorted ascending lexicographically by the respective ID or FIFO
• Given a user downloads the full export sheet for samples, measurements and raw data url the entries are sorted ascending lexicographically by the respective ID or FIFO

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

This issue is stale because it has been open for 30 days with no activity.