2. PHPRunner General questions
  3. case where list detail records don't show
This topic is locked

case where list detail records don't show

 		8/4/2010 9:02:03 PM
PHPRunner General questions
E
 electromotive author

PHPRunner 5.2 (5482)

Here's a case in a master/detail list where (some/all of) the detail records don't show.
Go directly to the detail table list. Use advanced search to select some obscure set or even an non-existent set. Leave it like that.
Sometime later, go to the master list, find a row where details exist, hover shows the details. Click on the details link. The detail records don't display.
This is because the $strWhereClause for the detail table is still active, from the previous advanced search. To get the details to show (or all of them to show), you have to go back directly to the details table, clear the search parameters, and then try the master-detail list again.
To see this more clearly, in the detail list page: Before SQL query add the following line:

echo "Where: ".$strWhereClause;
So, how do I work around this? Or how do I clear the previous detail's $strWhereClause when I do a new master-detail list?
J
 		Jane 8/5/2010

Hi,
thank you for pointing me to this bug.

We'll fix it in the next update.
To make your pages working open generated classes/listpage.php file, find this code:

$_SESSION[$this->sessionPrefix."_search"] = 0;



and replace it with this one:

unset($_SESSION[$this->sessionPrefix."_advsearch"]);


Also you can apply the same changes in the source files.
E
 		electromotive author 8/5/2010

Thanks, will try.

I wanna say, that PHPR 5.2(5482) has been remarkably bug-free. Outstanding really!