I’ve had this idea rolling around in my head for a bit, to basically make a function that
can turn any tableset, dataset, etc, into a BAQ on the fly, in runtime, for dashboards.
Basically say, you have a BO, and it returns a tableset, dataset, whatever, and you’d
like to pull that directly into a dashboard, without making a BAQ.
The function would be masquerading as a BAQ, both for building the dashboard, and
running it in runtime.
It sounds useful and neat to me, but with Kinetic grids, can’t they basically eat any
dataset or tableset anyway?
Since we are moving into the future, should this be a thing?
I can see tables with hundreds of columns being a frustration for users who haven’t fully experienced the data model gauntlet. I for one would want to do some curation of what’s accessible and what gets returned.
I guess I don’t see the advantage of having something do it on the fly. I suspect as soon as you started to use it you’d want to have “some” additional control that would require the ability to hide , show, filter etc fields and by that point you might as well go to a BAQ.
That’s kind of the same, but also not. This is more to eat anything, without the boilerplate.
I said “on the fly”, because the conversion is dynamic. You feed this a tableset, dataset, linq query, external data, etc, and it spits out the structure of a baq (if you need it), and the formatted data set when you want it.
Here is an example, I make a function with some linq in it, spits out some data. You call for a BAQ like from a dashboard or a BAQ Report, or whatever eats BAQs. It says, oh that’s a dynamic BAQ, go get it from the masquerade function. It transforms it into BAQ format. Everything flows through.
And of course, I would provide the framework for that, how far I would go with it, I don’t know.
I would at least be passing all the execution options, filters, etc to wherever the data comes from.
Not sure if I would do anything with it or leave that as an exercise for the designer.
And for many situations you are probably correct, but some not.
