This topic is locked
[SOLVED]

Populate Report With SQL View Procedure

2/2/2023 5:03:37 AM
PHPRunner General questions
L
Lawrence Nyaga author

i have a mysql procedure which works fine when i test it on phprunner, but my report page is empty.
when i run the following test
img alt

i get the following data back

img alt

mysql log shows.the parameter was passed.properly

img alt

when i go to the report page.on first load.the procedure runs properly.
becuase it supposed to populate only the first column if no parameters are passed.
in this case 0 and 0 , which is fine

img alt

img alt

But
When i add search values ,i expect the procedure to run with new values.which it does.but the grid is empty.

here i am Adding search value.

img alt

img alt

i am sure i am missing something.can someone please point me in the right direction?

L
Lawrence Nyaga author 2/14/2023

I contacted support and they told me,now that
my database procedure doesn't return Year and Month fields, when PHPRunner filters the data returned from the database, none of the records fit the search criteria.
so they asked to do the following.
On the Source screen press 'Generate PHP code', then remove or comment out this snippet:

---------------------------------------
// filter results, apply search, security & other filters
$result = $dataSource->filterResult( $result, $command->filter );
---------------------------------------

This did the trick.Thanks Support.