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 filter field, 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 filters are primarily meant to be a security feature, they can also be used as a scalability feature, as described in the following sections: