atk4 / report

Reporting extension for Agile Data
https://agiletoolkit.org/
MIT License
3 stars 6 forks source link

action('fx', ['sum', 'amount']) with joins #1

Open romaninsh opened 7 years ago

romaninsh commented 7 years ago

My union model contains joins. When I try to get sum of all amounts the query fails, because derived tables are configured to provide only amount and therefore join is failing.

I think when performing join on the top-most table, it should mark several fields as "system" which would be automatically included in all the derrived table queries.