Problems in filter

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,

  1. What platform version do you use?
  2. What are the steps to reproduce your problem?

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:

image

2º Add the column:

image

3º Select a range:

image

And we when click on search, appears the next message:

image

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>

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>

This XML looks fine. I cannot reproduce your problem, so if possible please attach a simple demo project where the problem appears