no-code Model combinations
Planned
When adding model combinations to a model, the dynamic list option requires SQL skills clients don’t always have, or oftentimes SSMS access to the database is not granted/possible for the users.
An improvement over writing SQL or generating a stored procedure to update Map tables would be to include the [MAP model combination] tables on the possible data sources and destinations for action rules in the rule designer.
-
Official comment
Hi Ignacio,
For this specific request, as it relates to configuring Dynamic Drop-Downs (Model Combinations), there's actually an undocumented feature in Kepion that was added in the past year that can accomplish this task. You can create a Data Rule that generates a View, and then in the Source Override section of the Drop-Down configuration screen you can specify this View.
*Note that the View needs to have the exact same table / column structure as the normal source table for a dynamic drop-down.
More broadly speaking, there are a number of other areas in Kepion where not needing to have direct Database access would make the configuration much easier. Having a way to do relational modeling, or affecting the tables directly from Kepion, is something we've wanted to put together for a long time, and we're aware of the helpful impact this would have on our partners.
In the meantime, I hope this helps out a little bit, thanks for leaving a comment!
Ian Britz
Operations Manager
Comment actions -
Ian,
Thanks for your reply. Actually, that feature helps a lot, I wasn't aware about it!
Won't this have any performance implications? Meaning, the application is going to consume a view rather than a table. I believe that this would depend on the complexity of the view itself, but anyhow.
Are you planning to add this feature in the near future? Or is something to be expected after the HTML5 full release?
Ignacio
-
Hi Ignacio,
Sorry for the late reply. Yes, this option could potentially hurt the performance of the Form, as every drop-down cell will be individually querying the same View. So depending on the number of drop-downs and the complexity of the View this could have serious performance implications.
The general new feature to allow relational modeling or database access directly from Kepion isn't likely going to be added in the near future. It's something we really want to develop, but it's a very large area,and something we would want to make sure we do correctly. It will certainly come after HTML5 conversion is complete.
Ian
Please sign in to leave a comment.
Comments
4 comments