how to set list page data where condition

newbiephp · Post by **newbiephp** » Wed Feb 05, 2020 3:41 pm

how to set list page data where condition.
but it still can display the standard add edit delete button.can it?

so I need to display data with a certain where.
thanks

arbei · Post by **arbei** » Wed Feb 05, 2020 4:52 pm

You may use Recordset_Selecting server event, see the topic Server Events and Client Scripts in the help file.

newbiephp · Post by **newbiephp** » Wed Feb 05, 2020 5:57 pm

ok thanks.

what if the data is set according to user level?
thanks

arbei · Post by **arbei** » Thu Feb 06, 2020 7:19 am

User level is table level, not related to data, the user just has or has not permission to the List page. Did you mean the table is protected by User ID security? You use Recordset_Selecting to add your filter, it will not affect User ID Security.