Retaining Found Set and Sort Order After Paging |
4/22/2025 2:36:54 PM |
| PHPRunner General questions | |
|
S
salus2 author
When I perform a find operation and sort the results, the first page of results shows found text hightlighted in red and the found count in the top right (perfect)...
...but going to the Page 2 using the paging controls at the bottom of the screen returns all records, unsorted...
Is there a way to configure so that Page 2, and subsequent paging, lists the next set of found records in the same sort order as designated on Page 1 instead? I've tried it with AJAX search, pagination, sorting enabled and disabled in the List_page settings, same result. I'm using V11 Enterprise 43257 You can see what I'm talking about at https://customdataservices.net/artgallery/items_list.php |
|
|
S
|
salus2 author 6/11/2025 |
|
Hello, |
|
|
S
|
salus2 author 8/26/2025 |
|
Is there a way to get update on if or when this issue might get addressed? Just tested with Enterprise 43708, same problem. |
|
|
Sergey Kornilov admin 8/26/2025 |
|
This is something that is not happening in our test projects and nobody else reported this. Must be something specific to your project or data, maybe some weird SQL query or some events causing this issue. You can check all the events that belong to this table, reset SQL query etc. You can also create a new test project to see if this issue is happening there as well. |
|
|
S
|
salus2 author 8/26/2025 |
|
Thanks for the reply. I'm surprised no one else reports it, I've never been able to get it to work properly. The example database is actually a stripped down version I created to verify the behaviour. Here is another example, a single table MySQL db, no event modications... https://customdataservices.net/canary/Employees_list.php Found sets and sort order are discarded when records are paged.
|
|
|
|
Sergey Kornilov admin 8/27/2025 |
|
You need to troubleshoot it further. There must be something related either to your database or to your web server. I would suggest test the same approach using a different database server and built-in web server. Install MySQL locally, create the same kind of table, build and run the project using the built-in web server just to see the difference. Again, this is not normal. This is a very basic functionality and we would have hundreds of bug reports if it wasn't working. |
|
|
S
|
salus2 author 8/27/2025 |
|
OK, thanks. I copied the database to a new server and all works as expected... I noticed that the URL in the new version retains all the necessary information during pagination but in the problematic version the URL is truncated during pagination to only include the goto... https://customdataservices.net/canary/Employees_list.php?goto=2 Any idea what would cause this difference in URL-generation behaviour? The servers, data set, and PHPRunner files are very similarly configured. |
|