2. PHPRunner General questions
  3. Pagination
This topic is locked

Pagination

 		8/28/2020 12:36:51 AM
PHPRunner General questions
U
 uli author

In the List page before record processed I exclude records after some criteria.

The number of pages and the pagination does not reflect the records not shown in the list.

What have I do to correct this.
Thanks for help.
Admin 8/28/2020

Pagination works with the results of the SQL query. If you are to hide certain records in the event later, PHPRunner would not know it.
If you need the pagination to work I would recommend hiding records adding WHERE clause as this article suggests:

https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm
U
 		uli author 9/23/2020



Pagination works with the results of the SQL query. If you are to hide certain records in the event later, PHPRunner would not know it.
If you need the pagination to work I would recommend hiding records adding WHERE clause as this article suggests:

https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm



My criterias to show or hide records are too complicated to put into a WHERE clause.

So has anybody an idea how to work with the paginanation before the list page is displayed.
Admin 9/23/2020

There is no workaround or fix. Things like this need to be handled on the database side in SQL query.