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?
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?
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