For a few weeks, we’ve been investigating possibly using Servoy for a large upcoming project.
I’m curious if there are any plans to make portals more flexible so they can contain fields from tables beyond a single relationship? Ie: If I have three tables related/chained, I could show a field from the third in a form based on the first, though the relationship as defined was from the first to the second. (That may actually be a more confusing description
Doesn’t the current method of defining relationships in Servoy already give it enough information to create statements to obtain recordsets with fields from directly and distantly related tables?
I can provide more description if helpful. I think everyone would agree this would be a fantastic feature and a great improvement over shipping versions of Filemaker, for example.
Using tabpanels in Servoy you can go as many relations deep as you want to. You can even nest tabpanels in tabpanels and display data that is many levels away.
I have to agree with JDW on this one - “this would be a fantastic feature and a great improvement”.
IMVHO, there are two isues here:
portals should encapsulate the functionality of a tableview in a tabpanel
relations should be able to be defined/specified non-adjacently
On the bright side, the way relations can be “chained” in javascript is very cool and illustrates the point
Whilst tabpanels are also cool, I don’t see how they help with say including a distantly related field in a portal. Also with related tables say A-B-C there are times when I find myself needing to retrieve all C records which are child of B records which are child of a particular A record - I can’t see how nested tabpanels help (I need the result as one foundset).