Pass the value to URL for an add page by custom view

PHPMaker General Discussion (PHPMaker)
1

Hi,
I am trying to pass the custom view value such “buchungen.SlodId” to an xxxadd.php page by using CASE.
Could you please advise where to start?

I should get a URL by “My Link” and when I click on it then the value of buchungen.SlotId should be inserted into add table…

Below is an example:

SELECT buchungstage.Id AS Id, buchungstage.Tag AS Tag,
Max((CASE WHEN (buchungen.SlotId = 9) THEN ‘Gebucht’ ELSE ‘My Link’
END)) AS 14:00-14:30,
…

FROM ((buchungstage LEFT JOIN
buchungen ON buchungen.Datum = buchungstage.Tag) LEFT JOIN
slots ON slots.Id = buchungen.SlotId) LEFT JOIN
dienste ON dienste.Id = buchungen.DienstId
GROUP BY buchungen.Datum


Thanks
mpol_ch

2

mpol_ch wrote:

SELECT buchungstage.Id AS Id, buchungstage.Tag AS Tag, Max((CASE WHEN (buchungen.SlotId = 9) THEN ‘Gebucht’ ELSE ‘My Link’ END)) AS 14:00-14:30…

  1. You cannot put PHP code “$this->buchungen_SlotId” in SQL.
  2. In the buchungenadd.php, you may get the value by @$_GET[“SlotId”] in server event (e.g. Row_Rendered) and set it to the EditValue of the field (assume the field is a textbox).