2. PHPRunner General questions
  3. report parameter
This topic is locked

report parameter

 		9/14/2020 05:44:53
PHPRunner General questions
M
 m.salahi author

hi every one
i create first report with simple sql
SELECT

USER_ID,

USER_FULL_NAME

FROM USERS

WHERE (USER_ID =':USER_ID')
it work in query results but in website not working
it's display nothing
i hop my question clear
Sergey Kornilov admin 9/14/2020

What is ':USER_ID' ?
M
 		m.salahi author 9/14/2020



What is ':USER_ID' ?


:USER_ID is the parameter

i want enter user_id to display results in website
Sergey Kornilov admin 9/14/2020

How do they enter this parameter?
The easiest option is to use Advanced Search page where users can enter UserID and it will be applied automatically to the SQL query. No need to change anything in the code.