Unable to get filtered results when filter is applied on a field where users looked up from another table.

[solankimihir]

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

[tea-artist]

This is a known issue and we will fix it #543

[solankimihir]

I am dumb! The original issue is also created by me. :smh: . Closing this issue. My apologies for the duplication.