[Bug] Inaccurate Transaction Sorting on Search Page When Mixing Currencies and Accounts

[satriotsubasa]

Describe the bug
When sorting transactions by amount on the Search Page, the results are not correctly ordered when the dataset includes multiple accounts with different currencies. It appears that the sorting algorithm first groups the transactions by account or currency, and only then applies the amount-based sorting within each group.

This results in an overall list that is not sorted purely by amount, which is counter to my expectations when the "Amount" is explicitly selected for sorting.

How to reproduce

1. Ensure your dataset includes several expense / income transactions from multiple accounts, each using different currencies (e.g., SGD, IDR, USD).
2. Navigate to search page
3. Sort by Amount descending
4. Observe the order of the transactions listed.
5. Notice that the amounts are not sorted in a globally descending order, suggesting that the sorting is being applied per account or per currency rather than across all records.

Screenshots/videos

Details

• Device: iPhone 14 Pro Max
• App Version: v6.0.9+451, db-v47

[Esildor]

@satriotsubasa How did you get monochrome category icons like this?

[satriotsubasa]

@Esildor it's beta testing version