Enhance Relation Definitions

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Enhance Relation Definitions

Postby jasantana » Fri Jun 17, 2011 12:03 pm

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.
Best regards,
Juan Antonio Santana Medina
jasantana@nephos-solutions.co.uk
Servoy MVP 2015
Servoy 6.x - Servoy 7.x - Servoy 8.x - MySQL - PostgreSQL - Visual Foxpro 9
User avatar
jasantana
 
Posts: 555
Joined: Tue Aug 10, 2010 11:40 am
Location: Leeds - West Yorkshire - United Kingdom

Re: Enhance Relation Definitions

Postby jwservoy » Fri Jun 17, 2011 10:53 pm

+1
________________________
Jason Walsh
ReadQ Technologies LLC
Servoy Certified Developer
jwservoy
 
Posts: 29
Joined: Mon Sep 14, 2009 10:35 pm
Location: New York, NY

Re: Enhance Relation Definitions

Postby jcompagner » Thu Jun 23, 2011 2:32 pm

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.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Enhance Relation Definitions

Postby jasantana » Thu Jun 23, 2011 3:49 pm

Hi Johan I see what you mean. What about allowing OR conditions?
Best regards,
Juan Antonio Santana Medina
jasantana@nephos-solutions.co.uk
Servoy MVP 2015
Servoy 6.x - Servoy 7.x - Servoy 8.x - MySQL - PostgreSQL - Visual Foxpro 9
User avatar
jasantana
 
Posts: 555
Joined: Tue Aug 10, 2010 11:40 am
Location: Leeds - West Yorkshire - United Kingdom


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 11 guests