This topic is locked

Report Page: Before SQL query

5/5/2016 1:57:12 AM
PHPRunner General questions
ffrinai author

Hi,

how is possible to use search panel variables in the event Report Page: Before SQL query for use in $strWhereClause ?

I have a record with multiple date fields and i'd like to use only one input in search panel.

es.

record fields: name,date1,date2,date3,date4

search panel :date1 option BETWEEN

i would like to have in $strWhereClause = date1 between date1 option of search panel values or date2 between date1 option of search panel values or date3 between date1 option of search panel values or date4 between date1 option of search panel values
I hope to be able to explain the problem

thanks