Virtualization: Database View insted of table
Currently I am in the final stages of a comprehensive evaluation test of BizAgi Enterprise 10.1.0.2020 .Net edition, and by the way, results are more than impressive this far. It's an incredible and amazing technology / solution what you have achieved.
After defining several, not so simple, processes, with corresponding workflows, messages, data models, forms and rules, I have a doubt about virtualization.
Currently I have several of replicated entities and one virtualized 'products' entity in the data model. 'products' entity is virtualized and not replicated because despite BizAgi doesn't need to write anything on it, data needs to be refreshed almost instantly, and has a fairly large ammount of rows.
The matter is that I'm getting an erratic forms behaviour when clicking the next button to advance cases, ending throwing the following error:
"Unable to process the case:Cannot update view of function 'vwM_Products' because it contains aggregates, or a DISTINCT or GROUP BY clause, or PIVOT or UNPIVOT operator"
vwM_Products is an SQL Server database view (not a proper database table). Does virtualization currently support virtualization over database views instead of tables? Could it be the source of the error?
Thank you very much in advance.