2. PHPRunner General questions
  3. Pagination and Page Size in Assign User To Group
This topic is locked

Pagination and Page Size in Assign User To Group

 		9/8/2021 12:56:14 AM
PHPRunner General questions
B
 BPTM MOSTI author

My system have more than 5000 users. I have problem to manage user in page "Assign User To Group", the page try to load all username in single page and make my system not responding. How to add pagination and page size in that page
A
 		AlphaBase 9/8/2021

Wow! 5000 users. Never thought of that. Sergey shoudl put in pagination and search. But in the mean time you could examine the security tables and build your own. Assign User To Group should be very easy to do, I think.
mbintex 9/9/2021

For adding a user to a group you can use this SQL code

INSERT INTO `MYSOLUTION_ugmembers` (`UserName`, `GroupID`) VALUES ('USERNAME', GROUPNUMBER);

Put this in a custom button and building your own user group page shouldn´t be that difficult.

But indeed PHPRunner should incorporate paging here, just for being safe.