Hi!
I try to search some information using filters. But, when I add a search condition appears the next error:
JpqlSyntaxException: Errors found for input jpql
However, when reviewing the database table (SEC_FILTER) , I see that CUBA insert the filter with a null parameter:
... <![CDATA[null.fechaEmision = :component$filter.fechaEmision06832]]>
And when I change the parameter manually by e, works correctly!
... <![CDATA[e.fechaEmision = :component$filter.fechaEmision06832]]>
How can I do to automatically generate the filter with the e?
Hi!
In the project there are other screens with filters and works correctly. So I think this problem is not realated to the platform version.
Steps:
1º Add search condition:
2º Add the column:
3º Select a range:
And we when click on search, appears the next message:
gorbunkov
(Maxim Gorbunkov)
#4
In the XML descriptor, what is the definition of the datasource/datacontainer related to the filter? Could you share it?
<window xmlns="http://schemas.haulmont.com/cuba/screen/window.xsd"
caption="msg://browseCaption"
focusComponent="quoteTable"
messagesPack="com.web.quote">
<data readOnly="true">
<collection id="quotesDc"
class="com.entity.Quote"
view="quote-view">
<loader id="quotesDl">
<query></query>
</loader>
</collection>
</data>
<dialogMode height="600"
width="800"/>
<layout expand="quoteTable"
spacing="true">
<filter id="filter"
applyTo="quoteTable"
dataLoader="quotesDl">
<properties include=".*"/>
</filter>
gorbunkov
(Maxim Gorbunkov)
#6
Why is the query
tag content empty?
Sorry! Is not empty, I forgot to copy it:
<query><![CDATA[select e from program_Quote e]]></query>
gorbunkov
(Maxim Gorbunkov)
#8
This XML looks fine. I cannot reproduce your problem, so if possible please attach a simple demo project where the problem appears