Equivalent to LEFT() sql function in JPA

Question

What is the LEFT() equivalent function in JPA?

I need to take only the first 6 characters of a field.

The equivalent select in sql would be:

select  left(campo,6), count(*) qtd
from tabela
group by left(campo,6)

Answer 1

No LEFT() function in jpa!

The documentation restricts the capture of string portions only to the [function] SUBSTRING().

ex:

select substring(v.campo, 1, 6), count(*)
from V v
group by substring(v.campo, 1, 6)