Error during a Relation Search

Mario_Ghersi · September 6, 2025, 9:09pm

Hi, working in the console each time I like to add a relation and want to search the record I found an error.

Any ideas ?

Thanks, Mario

Volodymyr_Ialovyi · September 8, 2025, 6:33am

We will be happy to assist you. I need to ask you a few more questions so I can understand the problem better.
Please provide your applicationId.

Only in the Users table? Does this happen on all tables?

Regards,
Volodymyr

Mario_Ghersi · September 9, 2025, 1:39am

Hi Volodymyr

App ID 147F3E51-266A-AAC4-FF2B-DFE9F84FD200
And the problem is on the all tables with relations.

My solution is to update the record I need at the final relation and then sort by update column to find easily, but take to much work for each relation I need to add.

Thanks, Mario

Alexander_Pavelko · September 9, 2025, 10:32am

Hello Mario,

I tried to reproduce the issue in my application, but everything works correctly on my side. Could you please create a test table where we can safely reproduce the problem without affecting your app or data, and share the exact steps to reproduce?

Regards,
Alexander

Mario_Ghersi · September 9, 2025, 1:29pm

Attachment available until Oct 9, 2025

Hi Alexander

Please check this movie, the problem is in all the tables in case of a search of a relation in any other table.

Click to Download

IMG_7104.MOV
32.2 MB

Thanks, Mario

Alexander_Pavelko · September 9, 2025, 3:14pm

Thank you for the video — it was extremely helpful in understanding the issue.

The query you used will only work when the SQL Search checkbox is enabled. When SQL Search is off, the search field performs a plain value search, so there’s no need to specify a column name. I’ve also created a ticket to improve the user-facing message in this case so the behavior is clearer.

Thanks again for reporting this!

Regards,
Alexander