I have a browser screen where the loading query has conditions as follows:
<loader id="attendSummaryDailiesDl">
<query>
<![CDATA[select e from erp_AttendSummaryDaily e]]>
<condition>
<and>
<c:jpql>
<c:where>e.company = :component_companyField</c:where>
</c:jpql>
<c:jpql>
<c:where>e.employee.operatingLocation = :component_operatingLocationField</c:where>
</c:jpql>
<c:jpql>
<c:where>e.attenDate between :component_dateFromField AND :component_dateToField </c:where>
</c:jpql>
</and>
</condition>
</query>
</loader>
The screen looks like below
When I enter the date in the field either “Date from” or “Date to” then getting the following exception. The reason is the query is executed immediately after entering either of those two date fields automatically. I tried to initiate date in the controller but getting the same problem. Thanks for suggesting a solution.
DevelopmentException: Parameter 'component_dateFromField' is not used in the query