Enhance Relation Definitions

Classic Servoy
1

Good morning from Gran Canaria.

I would like to know how many of you would like to have a better Relation Definition.

Right now you can do it with an interface that allows you to create “AND” filter expressions and I´m sure that including “OR” expressions would be great.

Going deeper, allowing us to avoid relation definition with an interface like that and letting us writting the SQL code could be even better. I do not know if this is possible, but I guess that what the relation definition does is translate the filtering into a SQL sentence and the execute it, so why not to let us the ability of writting the SQL code?

What do you think, should I post a feature request in the support site?

Thanks.

2

+1

3

relation based on plain sql code will be a no go in servoy
because we have to know what is build on in our caching behavior. Else we have no idea when to refresh relations when updated or new records are coming in.
But maybe based on something more high level that describes a sql query could be possible in the future.

4

Hi Johan I see what you mean. What about allowing OR conditions?