get the match ids for a relation

Classic Servoy
1

Is it possible to get the id fields used in the relation.

for example
relation “contact_to_company”

the fields used for the match are contact.company_id and company.company_id

Some how I want to manipulate the relation and get the above two columns.

2

Hi Hameed,

You can’t alter (servoy) relations by code. They can only be defined in design mode.
If you want to define relations in code you have to use plain SQL.

Hope this helps.

3

Hi Robert,

I know I could not alter the relationship definition through code.
Actually I do not want to do that.
I just wanted to read the relationship definition using code.

Is that possible?

4

Hi Hameed,

There is no function in Servoy to get that info. The only way would be to query the repository DB directly but that ain’t pretty.

5

Thanks!

I was aware of querying the repository database.
But I guess it is not pretty and recommended.
The repository database structure may change in the future (as it seems to do from 2.x to 3.x) then I would be in a mess. May be something Servoy can look in to it.

OR if the Servoy plugin API allows this to do I would try to create a plugin.

does the plugin API allow this?

6

No. You can find your way, but there is no straightforward way.