Depending on how SIS or HR data sources are configured, it may be necessary to add criteria to the queries that pull data from them. One example would be an HR datasource that contains all person records and needs to be altered to exclude undergraduate students.
If your data source is a standard one, using the built-in settings:
- Go to Maintenance > SIS/HR Mappings > SIS/HR Integration Settings.
- Find either SIS SQL WHERE Clause or HR SQL WHERE Clause, as appropriate.
- Enter one or more criteria in SQL. Example: Pers_Affiliation <> 'UG' AND Pers_Affiliation IS NOT NULL
If you have a custom interface to the datasource, such as LDAP, SOAP or a stored procedure, the interface code itself must be modified to include the criteria.
LDAP queries have their criteria in the filter argument. Contact your LDAP administrator for assistance with filter syntax.