A security filter is an optional Yes/No expression that is evaluated for each row in a table. If true, the row is included in the app and if false, the row is not included.
To configure a security filter for a table, do the following:
- Open the app in the app editor.
- Go to Security > Security filters .
- Expand the table for which you want to add a security filter.
- In the Security filterfield, define an expression to restrict the rows displayed.
You can also define security filters when configuring table settings .
To limit user access to a user's own data, require user sign-in
and use the user's email address to filter the data shown to that user, as described in Limit users to their own data
. For example, to display only items assigned to the current user, set the security filter condition to: [AssignedTo]=USEREMAIL()
While security filtersare primarily meant to be a security feature, they can also be used as a scalability feature , as described in the following sections:
