JPQL parameter error

Support
#1

I think I’m having a bug with the parameter in Jpql inside the report in jmix flow ui, can you help me please

image

image

If I place the data directly in the where, it works, but so by parameter it gives me the following error:

ReportingException: An error occurred while loading data for band [formJpql] and query [dataSet1]. Report name [formjpql]
An error occurred while loading data for data set [dataSet1]
You have attempted to set a value of type class com.uyuca.
entity.Wedding for parameter param_1 with expected type of class java.util.UUID from query string select
e.email ,
e.name ,
e.phone from uyuca_Form e
where e.id = :param_1.

#2

Hey, I am not 100% seguro but your param “form_id” is of type Entity and the error message indicates you set it to an entity “Wedding” where your query expects an ID. So either change your query to “where e = ${form_id}” or make sure to give a real UUID for the parameter.
Sorry if I am wrong here but I don’t see the bigger picture of the aplication.

1 Like