Grouper Users - Open Discussion List

[Ryan Rumbaugh <>]

Hi all,

 

I wanted to follow up on my last email in case others run into this issue. We were able to fix this issue after making adjustments to our subject.properties file. The diff is below for reference.

 

I *think* the secret sauce was defining a subjectAttributeCol and subjectAttributeName that matches the field/column we specified in sortAttribute and searchAttribute.

 

 

@@ -62,29 +62,39 @@ subjectApi.source.jdbc.param.subjectIdCol.value = NUID

 

# the column name to get the name from

subjectApi.source.jdbc.param.nameCol.value = DISPLAYNAME

+subjectApi.source.jdbc.param.descriptionCol.value = DESCRIPTION

 

-#subjectApi.source.jdbc.param.descriptionCol.value = DISPLAYNAME

+subjectApi.source.jdbc.param.emailAttributeName.value = email

 

# search col where general searches take place, lower case

-subjectApi.source.jdbc.param.lowerSearchCol.value = SEARCHFIELD

+subjectApi.source.jdbc.param.lowerSearchCol.value = DESCRIPTION_LOWER

 

# optional col if you want the search results sorted in the API (note, UI might override)

-subjectApi.source.jdbc.param.defaultSortCol.value = DISPLAYNAME

+subjectApi.source.jdbc.param.defaultSortCol.value = DESCRIPTION

 

# you can count up from 0 to N of columns to search by identifier (which might also include by id)

-#subjectApi.source.jdbc.param.subjectIdentifierCol0.value =

+subjectApi.source.jdbc.param.subjectIdentifierCol0.value = NUID

 

# you can count up from 0 to N of columns to search by identifier (which might also include by id)

-#subjectApi.source.jdbc.param.subjectIdentifierCol1.value = penn_id

+subjectApi.source.jdbc.param.subjectIdentifierCol1.value = DISPLAYNAME

 

# now you can count up from 0 to N of attributes for various cols.  The name is how to reference in subject.getAttribute()

-subjectApi.source.jdbc.param.subjectAttributeCol0.value = EMAIL

+subjectApi.source.jdbc.param.subjectAttributeCol0.value = NUID

 

# you can count up from 0 to N of attributes for various cols.  The name is how to reference in subject.getAttribute()

-subjectApi.source.jdbc.param.subjectAttributeName0.value = email

+subjectApi.source.jdbc.param.subjectAttributeName0.value = nuid

 

-#subjectApi.source.jdbc.param.subjectAttributeCol1.value = SEARCHFIELD

-#subjectApi.source.jdbc.param.subjectAttributeName1.value = searchfield

+subjectApi.source.jdbc.param.subjectAttributeCol1.value = EMAIL

+subjectApi.source.jdbc.param.subjectAttributeName1.value = email

+

+subjectApi.source.jdbc.param.subjectAttributeCol2.value = DISPLAYNAME

+subjectApi.source.jdbc.param.subjectAttributeName2.value = displayname

+

+subjectApi.source.jdbc.param.subjectAttributeCol3.value = DESCRIPTION

+subjectApi.source.jdbc.param.subjectAttributeName3.value = description

+

+subjectApi.source.jdbc.param.subjectAttributeCol4.value = DESCRIPTION_LOWER

+subjectApi.source.jdbc.param.subjectAttributeName4.value = description_lower

# now you can count up from 0 to N of attributes for various cols.  The name is how to reference in subject.getAttribute()

#subjectApi.source.jdbc.param.subjectAttributeCol1.value = description_lower

 

@@ -93,12 +103,12 @@ subjectApi.source.jdbc.param.subjectAttributeName0.value = email

 

# the 1st sort attribute for lists on screen that are derived from member table (e.g. search for member in group)

# you can have up to 5 sort attributes

-subjectApi.source.jdbc.param.sortAttribute0.value = DISPLAYNAME

+subjectApi.source.jdbc.param.sortAttribute0.value = description

 

# the 1st search attribute for lists on screen that are derived from member table (e.g. search for member in group)

# you can have up to 5 search attributes

-subjectApi.source.jdbc.param.searchAttribute0.value = DISPLAYNAME

-subjectApi.source.jdbc.param.searchAttribute1.value = EMAIL

+subjectApi.source.jdbc.param.searchAttribute0.value = description

+#subjectApi.source.jdbc.param.searchAttribute1.value = EMAIL

 

 

From: <> On Behalf Of Ryan Rumbaugh
Sent: Friday, November 9, 2018 12:12 PM
To:
Subject: [grouper-users] Grouper UI Filtering Issue

 

We’re having an issue filtering and sorting members of a group and I’m hoping others can provide some tips on how to solve.

 

It’s pretty simple to reproduce for us. Just add anyone directly to a group and attempt to search--no results will be found.  Interestingly, when someone is added to a group and the mouse is hovered over the entry, no popup is displayed either and sorting is not an option either. Is there a subject.properties setting we missed or do we need to modify some defaults in grouper-ui.properties? We’re running tier/grouper:2.3.0-a109-u47-w12-p21 if that helps.

 

Example with screenshots below:

 

A test group with myself as the only member, added directly.

 

When filtering using my first name, nothing appears.

 

--

Ryan Rumbaugh

Identity Management Specialist

Cybersecurity & Identity |ITS|

501 123.1, 68588-0203

University of Nebraska |nebraska.edu

Kearney|Lincoln|Omaha

402-472-0831 (o)