This guide is designed to help users who wish to restrict which people certain IDRegister Admin users can view. This is configured in the IDRegister Admin 'Users' section, once you have your login created you'll need to highlight them and use 'Edit User' to apply any filters, we'll use 'test' in this example - shown below:
We'll be using a very small data set in this example but it we'll be able to demonstrate most situations, this set is shown below:
Applying a filter based on class:
In this example we'll restrict the users that the login can see to people in class 3A. You'll need to ensure you surround the class you're entering with apostrophes.
Applying a filter based on year group:
In this example we'll restrict the users that the login can see to people in year 3, we use 'House' as reference to the Year as this is the field name in the database. You'll need to ensure you surround the year you're entering with apostrophes.
Applying a filter based on Person ID prefix:
If, for instance, you have students from multiple schools that have different prefixes showing in their Person ID's, you can use a 'LIKE' statement to match against the prefix part. You'll see after the 'BIO-' prefix we've added a % symbol, this is a Wildcard character which is used to substitute one or more characters in a string, this allows us to find all users that begin with 'BIO-', shown below:
*Note: We use 'StaffID' for both Staff and Students, this is just how we refer to the field in the database.