LCFS - BUG - Transaction ID Column Sorting Incorrect on BCeID and IDIR Transaction Pages

[airinggov]

Describe the Bug:
The Transaction ID column does not sort correctly on both the BCeID and IDIR transaction pages. Instead of sorting numerically, the IDs are sorted as text, leading to incorrect sequences such as CR1, CR100, CR11 instead of CR1, CR11, CR100.

Expected Behaviour:

• The Transaction ID column should be sorted numerically, ensuring IDs appear in proper sequential order.
• Sorting should maintain grouping by prefix.

Actual Behaviour:

• Sorting treats transaction IDs as text rather than numbers.
• Incorrect sequences occur, such as CR1, CR100, CR11 instead of CR1, CR11, CR100.

Implications:

• Users cannot efficiently locate or track transactions.
• Sorting inconsistencies may lead to reporting errors or confusion.
• The issue affects both BCeID and IDIR users, impacting multiple roles.

Steps To Reproduce:
User/Role: BCeID or IDIR

1. Navigate to the Transactions page.
2. Click on the Transaction ID column to apply sorting.
3. Observe that IDs are not sorted numerically but as text (e.g., CR1, CR100, CR11).
4. Verify that sorting fails to follow expected numeric order while maintaining grouping by prefix.

Notes:

• Update sorting logic to recognize and sort numeric values correctly, even when prefixed (e.g., "CR").
• Ensure sorting behaves correctly across different transaction ID formats.
• Test sorting behavior across both ascending and descending orders.
• Validate fix for both BCeID and IDIR transaction pages.