Originally shared by David Berneda
Originally shared by David Berneda
New "Dynamic Filter" class and editor dialog.
All tables and fields related (master-detail linked) to any data or query are shown on a tree with their individuals values to check / uncheck the desired ones.
This automatically creates a "filter expression" that is applied to the output data.
Date-Time values have an special subdialog to choose the range to filter (ie: "Last Month", and / or "Thursdays and Saturdays" etc)
Output is refreshed "live" in milliseconds to any control using the data (a BIGrid or BIChart etc). The BIQuery editor includes this Dynamic Filter for a really-visual way to create queries and pivot-tables without sql or code.
This looks awesome. As I see how TeeBI is developing it seems you're effectively making a Tableaux component for Delphi. I need to look deeper into this. It could be a great addition to our mapping package (https://www.alignmix.com)
ReplyDelete/sub
ReplyDeleteSteve Maughan Yes ! that's the long-term idea, robust basic classes with zero/few dependencies pure Delphi code (and C#) to use them in more advanced / specific projects like yours. The main interest is on expanding TeeChart, but chart-related code is totally independent and can be used without it
ReplyDelete