Sometimes you want to show existing data in the different format (for report, inquire or corporation purpose).
In my example I want to show you how to transform transform database table into something different. I have a table with years, groups and values, I want to group data by year and compare it between selected years.
- YearGroup – DAC for selecting data from database table.
- YearFilter – virtual DAC for storing year what we want to compare.
- VirtualComparasion – virtual DAC for showing grouped data in UI.
Also please notice, that we can clear cached data on filter update, so system will recalculate compared data on next callback.