Filtering Lookup does not work if the source field is "User"

[solankimihir]

Describe the bug
If you lookup any field which is a "User" type from Table B to Table A, and then apply filter on that lookup. The filter will not work correctly.

To Reproduce
Steps to reproduce the behavior:

1. Create Table A with a column for "User Type"
2. Create Table B
3. Link Table A and B [(Table A)One to Many(Table B)]
4. In Table B , create a new column with "Look up" to Table A "User Type" column
5. Apply Filter in Table B. The filter will not work correctly.

Expected behavior
I should be able to filter based on user name in Table B

Screenshots
Table A:

Table B:

Relation of Table A and Table B:

Filter Applied:

After applying filter, the results is blank.
Ideally, I should be seeing 2 records mapped to me.

** Client (please complete the following information):**

• OS: [e.g. iOS] : Windows 11
• Browser [e.g. chrome, safari] : Firefox
• Version [e.g. 22] 124.0.2 (64-bit)

Platform (Please tell us which deployment version you are using)

• Teable IO
• StandAlone Docker

[tea-artist]

Thank you for your detailed feedback, We reproduced the bug and will fix it soon.