2. PHPRunner General questions
  3. [SOLVED]  Select Really All Records On List Page
This topic is locked
[SOLVED]

 Select Really All Records On List Page

 		3/20/2013 3:24:43 AM
PHPRunner General questions
W
 wpl author

Dear all,
how could one manage to select really all records of the resultset of e.g. an advanced search and not only all records on the (first, second) page with the select all checkbox? To select "display all records" on one page first is not an option.
Thanks
S
 		swanside 3/20/2013



Dear all,
how could one manage to select really all records of the resultset of e.g. an advanced search and not only all records on the (first, second) page with the select all checkbox? To select "display all records" on one page first is not an option.
Thanks



Depends on what you want to do,
From the advance search, you have all your results. You can select all from the checkbox above the results, you can select to show all in the results on a page and then check the checkbox. If you want to export, you can click on export results and select all records!
W
 		wpl author 3/20/2013



Depends on what you want to do,
From the advance search, you have all your results. You can select all from the checkbox above the results, you can select to show all in the results on a page and then check the checkbox. If you want to export, you can click on export results and select all records!


swanside,
thanks for your input. I want to use the result of the advanced search with a custom button, sometimes I want to simply use all records in given the table. All records will almost never fit on one page, the results of the advanced search in most cases also. "Show all" is not an option since it will take too long in most cases.
Thanks
Sergey Kornilov admin 3/20/2013

Since you always need to work with the whole data set there is no need to make user select any records. Simply make this button to process all search results.
I would suggest to use BeforeSQLQuery event to save SQL query or WHERE clause in session variable and then use this session variable to access the whole data set in your button's OnServer code.
W
 		wpl author 3/20/2013



Since you always need to work with the whole data set there is no need to make user select any records. Simply make this button to process all search results.
I would suggest to use BeforeSQLQuery event to save SQL query or WHERE clause in session variable and then use this session variable to access the whole data set in your button's OnServer code.


Sergey,
that's what came into my mind, also. But as the access to all records is only needed sometimes, I would need a dual approach: keep the possibility to select records and process with custom button1, make a custom button2 to use all records of the result set, ignoring any seletion, with the method you suggested.
Thanks