teableio
Unable to get filtered results when filter is applied on a field where users looked up from another table.
Describe the bug If you have a field which looks up users from another table, and then you try to apply filter to that field to filter out rows mapped to specific user, I get 0 records.
To Reproduce
Create a table with clients as such:
Create a table with Tasks (Linking to the clients table above):
Now Lookup the "Mapped to" user from Clients table in Tasks Table:
The Tasks table would look as follows:
Now apply filter for a specific user:
After applying filter, the filters, 0 records are fetched:
Expected behavior Tasks mapped to that specific user must be shown as filtered rows
Screenshots Screenshots in line with description above.
** Client (please complete the following information):**
- OS: Windows
- Browser Firefox
- Version 126.0b8 (64-bit)
Platform (Please tell us which deployment version you are using) Teable.io and Docker both have same issues
Additional context N/A
