Filter Out Records Of FoundSet

Classic Servoy
1

I would like to filter out records of an existing found set or put another way, get a sub set of an existing foundset and load it into a form.

I was looking through the DatabaseManager but it is like reading greek!
Is the DatabaseManger on the right track?

Jim

2

gte451f:
I would like to filter out records of an existing found set or put another way, get a sub set of an existing foundset and load it into a form.

I was looking through the DatabaseManager but it is like reading greek!
Is the DatabaseManger on the right track?

Jim

Maybe you can do it constraining your foundset, using a search.

3

Thanks Ric,

I dug around in the manual for using kew word “Search” and came up with a way to reduce or extend a foundset but only after having built a find from scratch via a method.

I am still a little lost. My original goal was to limit a given found set of a form when ever a user did a “Show All” “Invert Records” or a Find. (Somthing like an addFilterParam but I want to filter by a related field which that won’t do.)

From what I understand I can’t start then pause a Find like in Filemaker. I also cannot piggy back on a standar Find with an additional method.

It sounds like the only way to go is having to rebuild a find from scratch, meaning, I have to build some additional form and let the user populate those values then I perform the find via method.

Well bummer, I started this whole think wanting to filter certain records from a form via a related field and this is quickly getting out of hand!

I hate to say it, but Filemaker had an easy way to get around rebuilding a find command by pausing a find and letting you enter your values on the same form before resuming the find.

I suppose, I can’t complain to much. Servoy is doing great things in other areas this aspect has just been difficult.

Feature Request
I would like to keep the great built in Find abilities Servoy offers AND be able to call a method either just before or after a user initiated find.

4

You could create a self join based on a field or a global to filter records. Silimar to a portal. I guess it depends on how many filter variables would be required.