Sorting on the table doesn't work when a filter is applied

[BeeBombshell]

OP: davidalonso#9125 on Discord Support Forum
Describe the bug
I have a table with filtering applied. Now, I want to sort my filtered data in descending order. When I tried to sort the data via the arrow buttons next to the column names, nothing happens.

To Reproduce
Steps to reproduce the behavior:

1. Set up a filter based on your data having multiple results.
2. Try sorting the data in ascending or descending order
3. The data does not get sorted with the filter applied.

Screenshots
Attaching a screen recording via https://jam.dev

https://jam.dev/c/7d5f454b-b0ed-4d8d-a7db-0b0b446ac409

Desktop (please complete the following information):

• OS: MacOS
• Browser: Chrome

[staticGuru]

@harinij
Can you assign the bug to me?

[BeeBombshell]

Hey @staticGuru, are you able to replicate this? An interesting thing to note, this issue does not occur on all tables. Rather, it is something specific to the table schema. Let me know if you need an exported table schema so that you can test it out. Here's a link to a relevant GitHub Discussion post.

[abegehr]

I'm running into the same issue. I would like to filter by user id and sort by a datetime field asc/desc. Both indexes exist in Firestore.

[aditya-armal]

Can you Assign this to me, I Am Interested.

[KrishavRajSingh]

I would like to work on this if no one is working.

[abegehr]

I ran into this again today for our table in rowy containing some user documents. I'd like to filter the table by user id column and sort by a timestamp column asc and dsc. The correct indexes are set in Firestore, howevever the filter+sort does not work in Rowy.