This topic is locked
[SOLVED]

 Dashboard records

7/14/2016 12:58:28 PM
PHPRunner General questions
T
thudsen author

Hi all. Asking for some help...
Here is my scenario.

I have a master table "Patient" with multiple details tables.
I'm using the dashboard to display the details tables and works very well. However, I'm stumbling across an issue when using the dashboard search.
There are patients in the master table with the same first name and date of birth, For example: John Smith 1/1/1990
If I show the master table in the dashboard as a data grid, it shows all the John Smiths. If I use the single record option on the dashboard it only shows the first John Smith from the search.
Is there a way I can pre-select the John Smith for the search, without having to show all the records and narrowing the search parameters too much, either in the grid or the single record? Alternatively is there a way to link directly to the dashboard view from the Master table list (e.g.: a button)?
Thanks

T
thudsen author 7/15/2016

I've solved this now
I added a button the list view of the table "patients"
In the button properties I added in Server

$result['SystemID'] = $keys['SystemID'];


In the Client After I added

location.href = "http://localhost:8087/Dashboard_dashboard.php?q=(patients_SystemID~equals~" + result['SystemID'] +")";


To enable this I set the dashboard advanced search field to allow it to search "SystemID".
Now when I click on the button it takes me to the dashboard showing only the master record for the selected patient, plus the related child records.