Dear support team,
I have created in my view an additional Checkbox with manual data and different text and values as follows:
Allgemein
"Sell", "data"=>array( "Out"=>"In", "Through"=>"Out", ), "display"=>"horizontal" )); ?>Then in my setup I've added into my SQL statement the needed param as following:
$this->src('autorep') ->query("
SELECT Sell, Geschaeftsjahr, Monat, WerbegruppeVerbund, NikonKdName, NikonProdGruppe, Verkaufsmenge, Umsatz
FROM Reporting.autorep_v_noNulls
WHERE
Sell IN (:Sell) AND
WerbegruppeVerbund IN (:Werbegruppe) AND
NikonProdGruppe IN (:NikonProdGruppe)
")->params(array(
":Sell"=>$this->params["Sell"],
":Werbegruppe"=>$this->params["Werbegruppe"],
":NikonProdGruppe"=>$this->params["NikonProdGruppe"]
))
echo $this->params["Sell"];
In the WHERE condition I put Sell column with IN as it's an array, right? Also I added at the end my setup func an echo to see whether the Sell param will be passed or not. But unfortunately nothing happen, means: - no echo if I check neither only "In" nor "Out" nor both options. - If I click on "Submit" the preselection on one of the checkbox is lost!
Here is my frontend:
Any idea what could be the reason?
Kind regards