Data Grid Display Problem

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.

[attachment=0]listUndefined.png[/attachment]

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

Thank you and kind regards
Birgit

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?

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

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