options -> QueryFrom - how to use?
Posted: 2019-12-11 15:59
Hi,
I saw that there is not ony a QueryWhere in the options, but also a QueryFrom.
In a tablename_view.php, when the table is named view_lagerbewegungsliste the line might look like
I tried to set this in the init function of the hooks/tablename.php to something else - which does not seem to work.
Am I doing something wrong - or does it actually not work?
This is of interest because IF if works, one could easily show a view as recordsource or even another table (with correct field names of course) in an AG layout by simply filling QueryFrom with some SQL.
Am I doing it wrong or is it not possible?
Olaf
I saw that there is not ony a QueryWhere in the options, but also a QueryFrom.
In a tablename_view.php, when the table is named view_lagerbewegungsliste the line might look like
Code: Select all
$x->QueryFrom = "`view_lagerbewegungsliste` ";Am I doing something wrong - or does it actually not work?
This is of interest because IF if works, one could easily show a view as recordsource or even another table (with correct field names of course) in an AG layout by simply filling QueryFrom with some SQL.
Am I doing it wrong or is it not possible?
Olaf