Data Grid Display Problem

[rieder]

Hi

A list, displayed in a data grid, does not always display the data providers correctly (see image provided). Only "undefined" is visible. And sometimes the grid has problems, lazy loading the full list. Then, scrolling just blocks.

listUndefined.png

Does anybody have an idea, what the reason could be?

Thank you and kind regards
Birgit

[Gabi Boros]

hard to see the reason from a screenshot, are there any errors in the logs? (servoy log/browser console); which version of Servoy/NG Grids do you use? does it happens also with the latest versions? do you have a sample to reproduce?

[rieder]

Hello Gabi

Thank you for the response.

We did not see any error in the server log. But did noch check the browser console. Since it happens now and then, I cannot reproduce it. And a sample solution would probably not show the same behaviour.

After a while (minutes), the "undefined" records get loaded and the names are displayed. But the scrolling problem persists: If the list contains more records (e. g. 700), sometimes not all records not get loaded and scrolling down has no effect (does not trigger loading).

I attach the SQL query (generated with the query builder) to load 81 records from the persons table (16352 records total).

We use
- Servoy version 2022.6.0 -releaseNumber 3782
- Servoy NG Grids 2022.6.1

Any idea what the problem could be?
Best regards
Birgit

Code: Select all

select
    persons.id
from persons
inner join persons_roles persons_roles
    on persons.id=persons_roles.person_id
inner join role_life_cycle_states role_life_cycle_states
    on persons_roles.role_id=role_life_cycle_states.role_id
    and persons_roles.role_life_cycle_state_status=role_life_cycle_states.status
where persons.discriminator = ?
    and role_life_cycle_states.status_flag = ?
    and persons.name like ?
    and persons_roles.role_id = ?
order by
    persons.name asc,
    persons.first_name asc,
    persons.id asc