JPA query with where clause

Support
#1

Hi, I want to the JPA query with like clause, but it throws exception. Plz find the below query.


<groupDatasource id="plan_Data_NewsDs"
                 class="com.keansa.keansacloud.entity.Plan_Data_New"
                 view="plan_Data_New-view">
    <query>
        <!&#91;CDATA&#91;select e from keansacloud$Plan_Data_New e
left join e.planUnit pu left join e.dataMeasureName
where pu.planUnit like 
concate(''pu.mdProductsVariety,'-',pu.mdGeographiesCountry'')&#93;&#93;>
    </query>
</groupDatasource>
#2

Hi,
What is the exception?

#3

Hi

Function concate doesn’t exists in the JPQL. Only CONCAT.

Thanks,
Subbotin Andrey