This topic is locked
[SOLVED]

 PHPR 10.3 bug

10/25/2019 6:05:39 AM
PHPRunner General questions
S
silk author

I tried to modify the query in the "Export page: Before SQL query" event with a simple:

$strSQL = "SELECT myField FROM myTable";
But it doesn't work. It works perfectly in the list page event

Sergey Kornilov admin 10/25/2019

You cannot change SQL query in this event. It will export the same data that appears on the list page.

S
silk author 10/28/2019



You cannot change SQL query in this event. It will export the same data that appears on the list page.


Actually I can successfully change $strWhereClause and $strOrderBy, I changed the main query and used those values to edit the export one