11.04.2022
11:17
Dear Webcon Community!
Problem: you cannot use datarow fields on portal reports.
Proposal: make it possible as it was a calculated field on report, running as subquery
What do you think?
Thank you!
BR,
Peter
11.04.2022
14:03
Working with databases for a very long time, there is an alert being triggered when i hear subquery. Using subqueries in reports usually ends up in poor performance.
So strongly advise against the usage of them.
11.04.2022
17:00
Working with databases for a very long time, there is an alert being triggered when i hear subquery. Using subqueries in reports usually ends up in poor performance.
So strongly advise against the usage of them.
Thank you Markus! You are absolutely right, we usually avoid using subqueries.
But regarding Webcon reports you do not have many alternatives, and for smaller tables it can work really well. We can either store redundant data or use same query in calculated field, but in my opinion my proposal is still better, if performance is manageable.
