Add the backing filters for the grids

App tutorial · Step 19 of 25

Build a three-form app that creates an Active Directory user and manages its group memberships.

In this step, we'll create filters to populate our two grid items.

1. Go to Processing > Filters.
2. Add a new filter named App_AD_User_Create_List_Groups.
3. For this filter, which we'll be using to populate the left grid, we simply need to get all groups in AD (because we potentially want to add our newly-created user to any or all of these groups). We'll include the objectGUID, distinguishedName, and cn columns. :::info The filter configuration is considerably simplified due to the fact that we're working with a brand new user, who we're confident will never have any existing group memberships. If the user might already have existing group memberships, the logic would be much more complex. :::
4. Click Save.
5. We'll copy the filter we just created, and rename the copy to App_AD_User_Create_No_Groups.
6. For this filter, which we'll be using to initially populate the right grid (groups that the user should be added to), we need the same columns as the left grid (to make our grids interoperable), but an empty data set. To accomplish this, we'll simply add an expression item that filters by a nonexistent condition, such as objectGUID = 1.
7. Click Save.