Retrieve all informations from a given Servoy relation

Classic Servoy
1

Hi,

Patrick and I, would like the following feature :

Being able to ask servoy all the relevant information of a given servoy relation, so I’d be able to rewrite it in SQL.

I reproduce patrick’s wording of the feature needed :

Vince wants to know from a relation

  1. the two tables involved
  2. the field matching used

As far as I see that, only question 1 can be answered with Servoy 3.5. In 3.5 you should be able to do

some_relation.getServerName()
some_relation.getTableName()

So you can figure out the right side of the relation. But what is missing is something like

some_relation.getFieldMapping()

that could return something like

[leftField][operator][rightField]

I can imagine useful application for this kind of thing.

2

I suggest you also post this in the bugbase so it’s logged.
(yes also feature requests are logged in the bugbase ;) )

3

Ok logged