2. PHPRunner General questions
  3. [SOLVED]  Details View
This topic is locked
[SOLVED]

 Details View

 		10/29/2019 6:34:57 AM
PHPRunner General questions
S
 Steve Seymour author

Does anyone have any idea why when viewing a table and its details view in a list page, not all details show.
Example: I have a Jobs table and its detail tables is Items.

When viewing the Jobs List View, then selecting to view Items, not all Items show.
Say a job has 4 items... only 2 show in the details.
If I go to the Items list view - they all show if I search for a Job # or filter on a job # all show as expected.
But from the Job table list view, selecting details only show 2 of the 4 items. There is nothing different about the items, no

filter settings, Job numbers are identical.
It is as if the SQL to show the details had a LIMIT = 2 for this job, but there is nowhere to set a limit ?
Any ideas would be appreciated. (PHPRunner version 10.3)
Thanks.

Steve
Sergey Kornilov admin 10/29/2019

We definitely do not limit the number of details records to be shown.
I would suggest starting troubleshooting using the advice provided in this article:

https://xlinesoft.com/phprunner/docs/debugging_tips.htm
S
 		Steve Seymour author 10/30/2019



We definitely do not limit the number of details records to be shown.
I would suggest starting troubleshooting using the advice provided in this article:

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


I've solved the issue. No SQL, custom code errors found.
Master Table has several detail tables. The table causing issues (only 2 of 4 records showing) had 2 of the details records added before a field in the master (non key field) was updated.

The other 2 detail records were created after the master record had a (non key) field value updated.
This means that PHPR appearsto be using multiple fields (not just the keyfield) to identify a record for the details link. It was only a problem displaying the details on the master tables list page.

Other ways to display the details worked and showed all detail records without issue.
example:
Master table: Field1 (key), field2, field3, field4.... field9
detail created.
Master table: Field1 (key), field2, field3 (updated) was empty, field4.... field9
detail created.
In the above example, Master table list - displaying details would only show the last added detail as that detail was created after a empty field

in the master table had a value added.
This suggests that updating/editing field values in the master table would stop the older details being listed, even when the edited field values are not key fields.