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