uPortal

Enterprise open source portal built by and for the higher education community.

This project is maintained by uPortal-Project

JDBC User Attribute Sources

The following configuration shows the JDBC-based user attribute source beans for handling user information in a caching mechanism.

```xml

SELECT DISTINCT first_name||' '||Last_name first_last, role, contentGroup, person_type, first_name, last_name, middle_name, email_alias, college, class_year, student_status, alias, work_phone, netid FROM person_directory_view where {0} displayName sn user.name.family uPortalAffiliation contentGroup mail user.home-info.online.email givenName alias personType College ClassYear StudentStatus uid netid username eduPersonPrincipalName user.login.id WorkPhone