Create a report with JPQL dataset. The query must use some external parameter and JPQL date macros, e.g.:
select
e.name as "name",
e.dueDate as "dueDate",
owner.login as "owner.login"
from sample_Project e
left join e.owner owner
where e.owner.id = ${owner1} and
@dateBefore(e.dueDate, now)
Run the report.
The exception:
Caused by: com.haulmont.yarg.exception.DataLoadingException: An error occurred while loading data for data set [Dataset]
at com.haulmont.reports.libintegration.JpqlDataDataLoader.loadData(JpqlDataDataLoader.java:91) ~[reports-core-7.2.19.jar:7.2.19]
at com.haulmont.yarg.reporting.extraction.controller.DefaultExtractionController.lambda$getQueryData$1(DefaultExtractionController.java:206) ~[yarg-2.2.11.jar:na]
at com.haulmont.yarg.reporting.extraction.DefaultPreprocessorFactory.lambda$new$0(DefaultPreprocessorFactory.java:35) ~[yarg-2.2.11.jar:na]
at com.haulmont.yarg.reporting.extraction.controller.DefaultExtractionController.getQueryData(DefaultExtractionController.java:204) ~[yarg-2.2.11.jar:na]
... 94 common frames omitted
Caused by: java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [select e.name, e.dueDate, owner.login from sample_Project e left join e.owner owner where e.owner.id = ?1 and (e.dueDate < :e_dueDate_1_1)].
[103, 105] Named and positional input parameters must not be mixed in a single query.
[123, 137] Named and positional input parameters must not be mixed in a single query.
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1750) ~[org.eclipse.persistence.jpa-2.7.3-19-cuba.jar:na]
It seems that for some reasons reporting replaces named query parameters with positioned ones.
Platform version: 7.2.19
Create a report with JPQL dataset. The query must use some external parameter and JPQL date macros, e.g.:
Run the report.
The exception:
It seems that for some reasons reporting replaces named query parameters with positioned ones.
Sample project: cuba-report-param.zip
The report: Report for entity Project - error.zip
Forum: https://forum.cuba-platform.com/t/email-templates-report-error-in-my-setup/16386