Restricting Foundset

Classic Servoy
1

I am trying to lock users to a pre defined foundset based on their login. What I am experiencing is that IF they type command J or show all from the menu they see all records. I am certain there is a way to lock the found set and am either overlooking it or mis understanding the process so any help would be appreciated.

FWIW - the user logs in a gets a set of data from a query which is loaded into the first form - thereafter I want them to work on this data set unless I programatically change the data set.

Cheers
Gordon

2

Hi Gordon,

Hope things are well with you :)

You have the following options based upon what your criteria are for limiting the foundset:

  1. addTableFilterParam

  2. addFoundSetFilterParam

  3. Take over the form events and control the onFind and onShowAllRecords etc commands

Which option you use is dependent upon what criteria are needed to limit the foundset on login

First step is for you to explore options 1 & 2 and see if either fit and only if not then go to option 3

If you are unsure then post the criteria that you need to live with

Cheers
Harry

3

Harry Catharell:
You have the following options based upon what your criteria are for limiting the foundset:

  1. addTableFilterParam

  2. addFoundSetFilterParam

Thanks Harry these are the ones I was looking for!!! I knew there was a method that did not include taking over the form properties.

Cheers
Gordon