Assigning named foundsets

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

Assigning named foundsets

Postby david » Wed Jun 20, 2012 12:53 am

Any progress on the ability to assign named foundsets to forms (design time and solution model)? default, separate, and empty have been the only options for awhile now and my understanding was that the namedFoundSet property was put in place to be able to share named foundsets between various forms. Which would save us a LOT of cludgy workaround code that we currently have in place to manage a multitude of forms doing different workflows but all based on the same table. Some of the forms we want the foundsets to stay in sync (ie, a list and a form) while being completely separate from other forms.

Original explanation by Robert Ivens that we couldn't agree with more:

viewtopic.php?p=19143#p19143
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Assigning named foundsets

Postby mboegem » Wed Jun 20, 2012 1:13 am

Hi David,

Progress on this feature was showed on ServoyWorld:
in the new v6.1, there's a possibility to use a relation as a 'named foundset'.
As you can now use literals in a relation (ie. don't need globals.one variable anymore to have a global relation on a certain table), you can see this as a find/search substitute.

Still not the real implementation we hoped for, but it's a start...
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Assigning named foundsets

Postby david » Wed Jun 20, 2012 1:32 am

Didn't know that, cool. There needs to be a way of defining "named foundsets" and relations seems like a good way to me. No problem with that.

We're on RC3 (the latest as of now) and I don't see how relations are assigned to the namedFoundSet property. Am I missing something or is this yet to be implemented?
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Assigning named foundsets

Postby mboegem » Wed Jun 20, 2012 10:14 am

Hi David,

this only works for relations using literals in the join.
relation.png
relation.png (4.58 KiB) Viewed 10452 times
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Assigning named foundsets

Postby david » Wed Jun 20, 2012 9:07 pm

Created a few literal join relations. How can you assign them to the namedFoundSet property of a form? Solution model only?
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Assigning named foundsets

Postby mboegem » Thu Jun 21, 2012 2:41 pm

In my example this relation can be assigned on a form based on table 'orders' via the namedFoundset property of the form.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Assigning named foundsets

Postby david » Thu Jun 21, 2012 6:25 pm

mboegem wrote:In my example this relation can be assigned on a form based on table 'orders' via the namedFoundset property of the form.


Ah k, finally got it. Also has to be a self relation. Which in hindsight makes sense.

I agree with your original assertion: this is not useful in its current iteration.

The way I see it working best is just being able to type in a name for namedFoundSet property (along with exposing getter/setter methods) and any forms that share this name and data source share the same foundset -- simple as that. Defining as a relation first seems a little hokey to me now and sets up unnecessary restrictions (even if all relations were implemented).
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Assigning named foundsets

Postby mboegem » Fri Jun 22, 2012 9:37 am

mboegem wrote:even if all relations were implemented


Shouldn't be needed anyway.
You could generate relations on the fly and also assign this new relation to the form using the solutionModel.
With a little smart coding you could even pass in your search-criteria and let the method do the rest.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Assigning named foundsets

Postby david » Fri Jun 22, 2012 9:47 am

mboegem wrote:
mboegem wrote:even if all relations were implemented


Shouldn't be needed anyway.
You could generate relations on the fly and also assign this new relation to the form using the solutionModel.
With a little smart coding you could even pass in your search-criteria and let the method do the rest.


I don't care about any of that for this feature. We just need to be able to separate foundsets out into chunks to control interaction. Doesn't matter what's in the foundset at this level. Do that down the chain.
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Assigning named foundsets

Postby david » Fri Jun 22, 2012 9:52 am

I'd rather use scopes to define named foundsets than relations.
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 6 guests

cron