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?
