Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

I am working on an admin tool in the UI which would help set up subject sources and identify problems with them.

 

I would like to add a section that shows what subjects look like in the UI in various places (and why).

 

Any comments or anything else you would like to see?

 

Thanks

Chris

 

 

 

Here is the full report (note passwords are not displayed, only admins can see the link and page):

 

SUCCESS: Found subject by id in 12ms: 'test.subject.0'

         with SubjectFinder.findByIdAndSource("test.subject.0", "jdbc", false)

SUCCESS: Subject id in returned subject matches the subject id searched for: 'test.subject.0'

WARNING: No subject found by identifier in 1ms: 'test.subject.0.id'

         with SubjectFinder.findByIdentifierAndSource("test.subject.0.id", "jdbc", false)

SUCCESS: Found 10 subjects by search string in 2ms: 'test'

         with SubjectFinder.findAll("test.subject.0.id", "jdbc")

SUCCESS: Found 10 subjects by paged search string in 2ms: 'test'

         with SubjectFinder.findPage("test.subject.0.id", "jdbc")

 

######## SUBJECT ATTRIBUTES ########

 

Subject id: test.subject.0 with subject.getId()

  - the subject id should be an unchanging opaque identifier

  - the subject id is stored in the grouper_members table

Subject name: my name is test.subject.0 with subject.getName()

  - the subject name is generally first last

Subject description: description.test.subject.0 with subject.getDescription()

  - the subject description can have more info such as the id, name, dept, etc

Subject type: person with subject.getTypeName()

  - the subject type is not really used

Subject attribute 'subjectid' has 1 value: 'test.subject.0'

 - with subject.getAttributeValue("subjectid")

Subject attribute 'name' has 1 value: 'my name is test.subject.0'

  - with subject.getAttributeValue("name")

Subject attribute 'lfname' has 1 value: 'name.test.subject.0'

  - with subject.getAttributeValue("lfname")

Subject attribute 'loginid' has 1 value: 'id.test.subject.0'

  - with subject.getAttributeValue("loginid")

Subject attribute 'description' has 1 value: 'description.test.subject.0'

  - with subject.getAttributeValue("description")

Subject attribute 'email' has 1 value: ''

  - with subject.getAttributeValue("email")

 

######## SOURCE CONFIGURATION ########

 

Adapter class: 'edu.internet2.middleware.grouper.subj.GrouperJdbcSourceAdapter'

  - configured in subject.properties: subjectApi.source.jdbc.adapterClass

SUCCESS: Found adapter class

SUCCESS: Instantiated adapter class

Source id: 'jdbc'

  - configured in subject.properties: subjectApi.source.jdbc.id

Source name: 'Example JDBC Source Adapter'

  - configured in subject.properties: subjectApi.source.jdbc.name

Source types: 'person'

  - configured in subject.properties: subjectApi.source.jdbc.types

Source param name: 'Name_AttributeType' has value: 'name'

  - configured in subject.properties: subjectApi.source.jdbc.param.Name_AttributeType.value

Source param name: 'subjectIdentifierAttribute0' has value: 'LOGINID'

  - configured in subject.properties: subjectApi.source.jdbc.param.subjectIdentifierAttribute0.value

Source param name: 'maxResults' has value: '1000'

  - configured in subject.properties: subjectApi.source.jdbc.param.maxResults.value

Source param name: 'jdbcConnectionProvider' has value: 'edu.internet2.middleware.grouper.subj.GrouperJdbcConnectionProvider'

  - configured in subject.properties: subjectApi.source.jdbc.param.jdbcConnectionProvider.value

Source param name: 'identifierAttributes' has value: 'LOGINID'

  - configured in subject.properties: subjectApi.source.jdbc.param.identifierAttributes.value

Source param name: 'sortAttribute0' has value: 'LFNAME'

  - configured in subject.properties: subjectApi.source.jdbc.param.sortAttribute0.value

Source param name: 'sortAttribute1' has value: 'LOGINID'

  - configured in subject.properties: subjectApi.source.jdbc.param.sortAttribute1.value

Source param name: 'Description_AttributeType' has value: 'description'

  - configured in subject.properties: subjectApi.source.jdbc.param.Description_AttributeType.value

Source param name: 'subjectVirtualAttribute_0_searchAttribute0' has value: '${subject.name},${subjectUtils.defaultIfBlank(subject.getAttributeValue('LFNAME'), "")},${subjectUtils.defaultIfBlank(subject.getAttributeValue('LOGINID'), "")},${subjectUtils.defaultIfBlank(subject.description, "")},${subjectUtils.defaultIfBlank(subject.getAttributeValue('EMAIL'), "")}'

  - configured in subject.properties: subjectApi.source.jdbc.param.subjectVirtualAttribute_0_searchAttribute0.value

Source param name: 'useInClauseForIdAndIdentifier' has value: 'true'

  - configured in subject.properties: subjectApi.source.jdbc.param.useInClauseForIdAndIdentifier.value

Source param name: 'SubjectID_AttributeType' has value: 'id'

  - configured in subject.properties: subjectApi.source.jdbc.param.SubjectID_AttributeType.value

Source param name: 'searchAttribute0' has value: 'searchAttribute0'

  - configured in subject.properties: subjectApi.source.jdbc.param.searchAttribute0.value

Source param name: 'maxPageSize' has value: '100'

  - configured in subject.properties: subjectApi.source.jdbc.param.maxPageSize.value

Source param name: 'emailAttributeName' has value: 'email'

  - configured in subject.properties: subjectApi.source.jdbc.param.emailAttributeName.value

Internal attributes: 'searchAttribute0'

  - configured in subject.properties: subjectApi.source.jdbc.internalAttributes

No attributes configured

Search 'searchSubject' param name: 'sql' has value: 'select    s.subjectid as id, s.name as name,    (select sa2.value from subjectattribute sa2 where name='name' and sa2.SUBJECTID = s.subjectid) as lfname,    (select sa3.value from subjectattribute sa3 where name='loginid' and sa3.SUBJECTID = s.subjectid) as loginid,    (select sa4.value from subjectattribute sa4 where name='description' and sa4.SUBJECTID = s.subjectid) as description,    (select sa5.value from subjectattribute sa5 where name='email' and sa5.SUBJECTID = s.subjectid) as email from    subject s where    {inclause}'

  - configured in subject.properties: subjectApi.source.jdbc.search.searchSubject.param.sql.value

Search 'searchSubject' param name: 'inclause' has value: 's.subjectid = ?'

  - configured in subject.properties: subjectApi.source.jdbc.search.searchSubject.param.inclause.value

Search 'searchSubjectByIdentifier' param name: 'sql' has value: 'select    s.subjectid as id, s.name as name,    (select sa2.value from subjectattribute sa2 where name='name' and sa2.SUBJECTID = s.subjectid) as lfname,    (select sa3.value from subjectattribute sa3 where name='loginid' and sa3.SUBJECTID = s.subjectid) as loginid,    (select sa4.value from subjectattribute sa4 where name='description' and sa4.SUBJECTID = s.subjectid) as description,    (select sa5.value from subjectattribute sa5 where name='email' and sa5.SUBJECTID = s.subjectid) as email from    subject s, subjectattribute a where    a.name='loginid' and s.subjectid = a.subjectid and {inclause}'

  - configured in subject.properties: subjectApi.source.jdbc.search.searchSubjectByIdentifier.param.sql.value

Search 'searchSubjectByIdentifier' param name: 'inclause' has value: 'a.value = ?'

  - configured in subject.properties: subjectApi.source.jdbc.search.searchSubjectByIdentifier.param.inclause.value

Search 'search' param name: 'sql' has value: 'select    s.subjectid as id, s.name as name,    (select sa2.value from subjectattribute sa2 where name='name' and sa2.SUBJECTID = s.subjectid) as lfname,    (select sa3.value from subjectattribute sa3 where name='loginid' and sa3.SUBJECTID = s.subjectid) as loginid,    (select sa4.value from subjectattribute sa4 where name='description' and sa4.SUBJECTID = s.subjectid) as description,    (select sa5.value from subjectattribute sa5 where name='email' and sa5.SUBJECTID = s.subjectid) as email from    subject s where    s.subjectid in (       select subjectid from subject where lower(name) like concat('%',concat(?,'%')) union       select subjectid from subjectattribute where searchvalue like concat('%',concat(?,'%'))    )'

  - configured in subject.properties: subjectApi.source.jdbc.search.search.param.sql.value