Looks like it's not supported in phpmaker, if that's so it will be a nice feature to add later.
Here is my case.
MyTableView
year INT,
activity_id INT,
quarter INT, //valid value: 1,2,3,4
activity_text VARCHAR
I need to filter activity list with quarter value. No problem.
But then I need activity to added up started from the YYYY-01-01 to date(now()). Something like "year to date" value.
I can do this easily with mysql:
select year, activity_id, count(activity_text) from myTableView GROUP BY year,activity_id
Or if I need all activity
select year, count(activity_text) from myTableView GROUP BY year
In other words, I need to input a value which then works to modify sql view.
Could I do that with built-in tables?