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:
- Generate test data using JMX bean
- Import filter using entity inspector from file FilterEntity.json
- 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.