[Due for payment 2025-08-13] [$250] Reports - Unable to sort results when there is more than 1 status in the search query

[lanitochka17]

If you haven’t already, check out our contributing guidelines for onboarding and email contributors@expensify.com to request to join our Slack channel!

---

Version Number: 9.1.87-0
Reproducible in staging?: Y
Reproducible in production?: Y
If this was caught during regression testing, add the test name, ID and link from TestRail: https://test-management.browserstack.com/projects/2148171/folder/12015331/test-cases/39318085
Email or phone of affected tester (no customers): applausetester+khcategory19@applause.expensifail.com
Issue reported by: Applause - Internal Team

Action Performed:

1. Go to staging.expensify.com
2. Go to Reports > Expenses
3. Click Status
4. Select Draft and click Apply
5. Click on any table header title (Date, Merchant, From, To, Category, Tag, Total)
6. Note that the results can be sorted by clicking on the table header title
7. Click Status
8. Select Draft and Outstanding (make sure account has these expenses)
9. Click Apply
10. Click on any table header title (Date, Merchant, From, To, Category, Tag, Total)

Expected Result:

The results can be sorted by clicking on the table header title when there is more than 1 status in the search query.

Actual Result:

The results cannot be sorted by clicking on the table header title when there is more than 1 status in the search query

Workaround:

Unknown

Platforms:

Select the officially supported platforms where the issue was reproduced:

• Android: App
• Android: mWeb Chrome
• iOS: App
• iOS: mWeb Safari
• iOS: mWeb Chrome
• Windows: Chrome
• MacOS: Chrome / Safari
• MacOS: Desktop

Platforms Tested:

On which of our officially supported platforms was this issue tested:

• Android: App
• Android: mWeb Chrome
• iOS: App
• iOS: mWeb Safari
• iOS: mWeb Chrome
• Windows: Chrome
• MacOS: Chrome / Safari
• MacOS: Desktop

Screenshots/Videos

Add any screenshot/video evidence

Bug6902134_1753805597312.20250730_000737.mp4

View all open jobs on GitHub

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~021950282533959919912
• Upwork Job ID: 1950282533959919912
• Last Price Increase: 2025-07-29

Issue Owner

Current Issue Owner: @lschurr

[melvin-bot]

Triggered auto assignment to @lschurr (Bug), see https://stackoverflow.com/c/expensify/questions/14418 for more details. Please add this bug to a GH project, as outlined in the SO.

[Eskalifer1]

Proposal

Please re-state the problem that we are trying to solve in this issue.

Reports - Unable to sort results when there is more than 1 status in the search query

What is the root cause of that problem?

Currently, this looks like expected behavior according to the code:

App/src/components/Search/index.tsx

Line 664 in e0bf4b3

const shouldShowSorting = !Array.isArray(status) && !groupBy;

What changes do you think we should make in order to solve the problem?

If this is no longer needed, you can remove this part: !Array.isArray(status) &&

What specific scenarios should we cover in automated tests to prevent reintroducing this issue in the future?

N/A

What alternative solutions did you explore? (Optional)

Reminder: Please use plain English, be brief and avoid jargon. Feel free to use images, charts or pseudo-code if necessary. Do not post large multi-line diffs or write walls of text. Do not create PRs unless you have been hired for this job.

[melvin-bot]

Job added to Upwork: https://www.upwork.com/jobs/~021950282533959919912

[melvin-bot]

Triggered auto assignment to Contributor-plus team member for initial proposal review - @s77rt (External)

[s77rt]

This is coming from #51838

@luacmartins Is the multiple status sort still an issue? I see we enabled this here #52185 but then disabled it again here #52280

[luacmartins]

That has changed a bit. We used status All to show transactions and all other statuses showed reports. We don't allow sorting on reports right now. That being said, we changed how statuses work and now you can look for transactions with any status, so we can sort on that.

[s77rt]

Thanks for confirmation

[s77rt]

@Eskalifer1 Thanks for the proposal. RCA and solution looks good to me. Let's get that fixed.

🎀 👀 🎀 C+ reviewed
Link to proposal