Database View Assistance - Problems with translation

[Carlos Petrucio]

Hello, I hope you are all well. I need help because I can't get a database view to work properly.

In this database view, we are displaying data from 3 tables.

- task_sla (SLA Table)

- ticket_my (Parent Tickets)

- task_my (Child Tickets, Tasks)

Below is the configuration for displaying the tables.

Problem: In the ticket record and in the task record, there is a field called u_item that is a reference field for "record producer" and displays the name of the record producer.

When I search in English in this column for the item name, it filters in the database normally.

Query -> "ticketmy_u_item.nameLIKEParts Identification"

But when I change my language to Brazilian Portuguese, the error below occurs:
Query -> "ticketmy_u_item.nameLIKEIdentificação de Peças"

Does anyone know why its happens?

[Gangadhar Ravi]

@Carlos Petrucio 

please check this https://www.servicenow.com/community/developer-forum/syntax-error-or-access-rule-violation-detected-...

Please mark my answer correct and helpful if this works for you.

[Erica]

hey @Carlos Petrucio . 
Were you able to solve the problem?

[Erica]

Issue: The field in question is a 'translated text' type. When the user changed their language setting, the database view came up empty.
Fix: I resolved this by pulling the data from a different field (a simple string type). The other option was to manually create localized versions of the record for each language, but that would have been very time-consuming.