Filter with a custom condition breaks rows counting

[ilya.rodionov (Ilia Rodionov)]

When using filter with a custom condition based on a child entity, like in code below, it breaks rows counting and hence rows browsing (paging). Actually rows counting become sensetive to “show rows” filter parameters.

<filter id="filter"
                datasource="ordersDs">
            <properties include=".*"/>
            <custom caption="Order Items contains"
                    join="join {E}.items i"
                    name="OrderItems"
                    paramClass="com.haulmont.sampler.entity.Product">i.product.id = ?</custom>
</filter>

I’ve implemented an example, please check this repo. To reproduce:

1. Generate test data using JMX bean
2. Import filter using entity inspector from file FilterEntity.json
3. Try to use filter - there are 3000 recs all, but if set year 2014 it will be either >3000 or below 50, like on this screenshots.

Regards,
Ilya.

[krivopustov (Konstantin Krivopustov)]

Try to add “distinct” to your query. See details here: Queries with distinct - CUBA Platform. Developer’s Manual

[ilya.rodionov (Ilia Rodionov)]

This works, thank you a lot.