Problems in filter

Support
#1

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?

#2

Hi,

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

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

#4

In the XML descriptor, what is the definition of the datasource/datacontainer related to the filter? Could you share it?

#5 
<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>
#6

Why is the query tag content empty?

#7

Sorry! Is not empty, I forgot to copy it:

 <query><![CDATA[select e from program_Quote e]]></query>
#8

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