[HOLD] SearchForReports query doesn't sort results

[m-natarajan]

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.0.52-5 Reproducible in staging?: Y Reproducible in production?: Y If this was caught on HybridApp, is this reproducible on New Expensify Standalone?: If this was caught during regression testing, add the test name, ID and link from TestRail: Email or phone of affected tester (no customers): Logs: https://stackoverflow.com/c/expensify/questions/4856 Expensify/Expensify Issue URL: Issue reported by: @JmillsExpensify Slack conversation: https://expensify.slack.com/archives/C05LX9D6E07/p1729007631513779

Action Performed:

1. Go to staging.new.expensify.com
2. Click Search on LHN
3. Click chat > Search icon
4. Enter workspace name in search field

   Expected Result:

   Search result sorted as expected (1.Order everything by the last message timestamp (descending) 2.When searching, self DM is put at the top 3.All archived reports should remain at the bottom)

   Actual Result:

   The workspace chat is not displayed

Workaround:

Unknown

Platforms:

Which of our officially supported platforms is this issue occurring on?

• [ ] Android: Standalone
• [ ] Android: HybridApp
• [ ] Android: mWeb Chrome
• [ ] iOS: Standalone
• [ ] iOS: HybridApp
• [ ] iOS: mWeb Safari
• [x] MacOS: Chrome / Safari
• [ ] MacOS: Desktop

Screenshots/Videos

Add any screenshot/video evidence

 https://github.com/user-attachments/assets/83c5fb3e-4e2f-4f05-80c2-05202610c2bb

View all open jobs on GitHub

[melvin-bot[bot]]

Triggered auto assignment to @alexpensify (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.

[melvin-bot[bot]]

Triggered auto assignment to @flodnv (AutoAssignerNewDotQuality)

[muttmuure]

@JmillsExpensify is this a CRITICAL #quality project?

[alexpensify]

@JmillsExpensify should this be an Internal or External GH? Thanks!

[flodnv]

Internal.

[flodnv]

I am a bit confused by the expected result @JmillsExpensify

1. Order everything by the last message timestamp (descending)
2. When searching, self DM is put at the top
3. All archived reports should remain at the bottom

Is this saying that this should be the order of things, assuming they are present in the results? Like:

1. Workspace chat
2. self dm
3. archived reports

? How does last message timestamp affect this? Like what if the last message in the self dm was 1 hour ago, and the last message in the workspace chat was 2 hours ago?

[alexpensify]

It's not overdue; we are waiting for feedback here.

[JmillsExpensify]

This should be on hold. It needs to go through the design process internally first. I'll also take it over.

[JmillsExpensify]

P.S. @luacmartins is going to take the lead on this one!

[luacmartins]

Posted whatsnext proposal. Gonna ship a pre-design by EOD tomorrow.

[luacmartins]

Tracking issue here

[melvin-bot[bot]]

@luacmartins Whoops! This issue is 2 days overdue. Let's get this updated quick!

[luacmartins]

I'll work on the HL doc this week

[melvin-bot[bot]]

@luacmartins Huh... This is 4 days overdue. Who can take care of this?

[luacmartins]

I still need to write the HL