2. PHPRunner General questions
  3. [SOLVED] help adding where clause in report
This topic is locked
[SOLVED]

help adding where clause in report

 		11/12/2023 1:34:08 PM
PHPRunner General questions
francesco author

This page comes from a search custom Button:

var popup = Runner.displayPopup( {
url: "distintabase2_report.php?q=(macchina~equals~X302)",
width: 900,
height: 800,
});

Inside this page I want to make a search on Descrizione field, keeping original search X302. I set up a session variable $_SESSION["mac"] = "X302";

How can I proceed setting up this where clause? I'm in report page.

img alt

Sergey Kornilov admin 11/13/2023

Check this article:
https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm
francesco author 11/13/2023

thanks i was able to solve adding

$query->addWhere("macchina.macchina='".$_SESSION["mac"]."'");

in After table initialized.