Hi!
I conducted an investigation and found out that the problem is in the filterComponent. As a result, your original query looked like this:
select e from Prueba e
where (
e.marcaTiempoTerminal >= :marcaTiempoTerminalcHRSmFVB
and e.marcaTiempoTerminal <= :marcaTiempoTerminalewUgGAWe
and e.codigoCentro LIKE 'T030%' OR e.codigoCentro LIKE 'T050%' OR e.codigoCentro LIKE 'T070%'
)
This is actually not the expected behavior. Logically, it is expected that each condition will be fulfilled separately.
Thus, the following request was expected:
select e from Prueba e
where (
e.marcaTiempoTerminal >= :marcaTiempoTerminalcHRSmFVB
and e.marcaTiempoTerminal <= :marcaTiempoTerminalewUgGAWe
and (e.codigoCentro LIKE 'T030%' OR e.codigoCentro LIKE 'T050%' OR e.codigoCentro LIKE 'T070%')
)
You can wrap your JPQL query condition in parentheses to make it work now:
To solve this issue, I created a ticket in our GitHub bug tracking system: The JPQL filter can be misleading when used in a group filter · Issue #2949 · jmix-framework/jmix · GitHub
Best regards,
Dmitriy