Not working properly a search in a relation

[Mario_Ghersi]

Application ID: 147F3E51-266A-AAC4-FF2B-DFE9F84FD200
Error UID: F9928CBB-0E11-4B58-A996-AC5D34170734

There seems to be an issue with the query. Please check the following sections for potential errors:
- SELECTED properties: []
- WHERE clause: objectId not in (`User`[`Controles`[`autorizado`].objectId='F9928CBB-0E11-4B58-A996-AC5D34170734'].objectId) AND (`cargo` like '%legal_id = '123123'%' or `name` like '%legal_id = '123123'%' or `face_data` like '%legal_id = '123123'%' or `updated` like '%legal_id = '123123'%' or `legal_id` like '%legal_id = '123123'%' or `lastName` like '%legal_id = '123123'%' or `created` like '%legal_id = '123123'%' or `ownerId` like '%legal_id = '123123'%' or `deviceId` like '%legal_id = '123123'%' or `telefono` like '%legal_id = '123123'%' or `peerId` like '%legal_id = '123123'%')
- ORDER BY: []
- GROUP BY: []
- HAVING clause: 
Hint: Offending token '123123' is placed between ''%legal_id = '' and ''%'', probably expected a token '8'.
Please review these parts of your query and try again.

Problem description

Describe what you did in console that led to the error. Please provide a description of what actually happens. Be descriptive: “it doesn’t work” does not describe what the behavior actually is. This will help us with reproducing the problem.

Steps to reproduce

Please describe steps to reproduce starting from the first action.

[mark-piller]

has it worked before?

[Mario_Ghersi]

Yes, but is a couple of months old at least.

[mark-piller]

Have you made any changes in the schema?

What is the name of the table where you send that query?

[Mario_Ghersi]

At “Controles” I need to add 1 “autorizado”

When I try to search like legal_id = ‘123’ give me error or any search.

I was invent different option like autorizados.legal_id = ‘123’ but was not correct.

This was legal_id = ‘123123’ a correct user should be found.

Maybe this helps.
Thanks, Mario

[mark-piller]

Do you have the SQL Search checkbox selected?

[Mario_Ghersi]

Thanks!!! Ready !
Mario

[mark-piller]

You are welcome