Pagination not working while we load entity through KeyValueCollections

Support
#1

When we used keyValueCollection the pagination of last arrow button is not working it is permanently disable.
image (1)

Pagination Not working for KeyValue Container
#2

Hi, @krushna.machhi

What Jmix version do you use?

Regards,
Maria.

#3

Jmix version 2.1.3

#5

HI Maria,

Any solution on it.

#6

Hello!

This is the expected behavior because the internal query transformer cannot correctly create a count query for KeyValueCollection.

The issue: SimplePagination total count calculation fails when using together with KeyValueCollectionContainer for FlowUI · Issue #1986 · jmix-framework/jmix · GitHub.

#8

Hi,

As per link Issue seems to be fixed and release on Release 2.1 on Dec 21, 2023 but still for keyvaluecontainer FinalLastpage button is disable and also for all pagination value is initially showing ?. Current Jmix version i am using is version '2.1.3'

<simplePagination id="pagination" dataLoader="masterDashboardDl" alignSelf="END" itemsPerPageDefaultValue="10"/>

<keyValueCollection id="masterDashboardDc">
                <loader id="masterDashboardDl">
                    <query>
                        <![CDATA[select e, t.name as parentMasterName from master e
                        left join master t on e.parentMaster = t.id order by e.modifiedOn desc ]]>
                    </query>
                </loader>
                <properties>
                    <property name="t1" class="com.company.Master"/>
                    <property name="parentMasterName" datatype="string"/>
                </properties>
            </keyValueCollection>

image

#10

Hello!

Take a look at “Solution” section in the linked issue. It says that “Last page” button should be disabled and “?” sign should not be shown for Key Value collections. The issue resolves only these statements.

for all pagination value is initially showing ?

I created a view with KeyValueCollection and do not see that “?” is displayed.