daledotshan/liferay-plugins — pull request #4 by yuhai (2013-09-20 08:03:53+00:00)
Title: LPS-40262  Members portlet(social networking): Site users assigned via User Groups not displaying

After we assign user group and organization to Site, those implict users(belong to user group or organization) also should to belong site member. So the fix add the code "userParams.put("inherit", Boolean.TRUE);" in view_members.jspf.

However, as for the following code

"OrderByComparator obc = OrderByComparatorFactoryUtil.create("User_", "loginDate", false, "firstName", true, "lastName", true);""

After using "userParams.put("inherit", Boolean.TRUE);", the sql change for the "(Select) UNION (Select...) UNION (Select...) ORDER BY User_.loginDate DESC,User_.firstName ASC,User_.lastName ASC)". So we need to remove the table name "User_".(Roll back LPS-30055).

Instead, use original code "new UserLoginDateComparator()", we may change the follwoing code to achieve the LPS-30055 function. I will submit the change in liferay-portal.

### in UserLoginDateComparator.java
redefine public static final String ORDER_BY_DESC ="loginDate DESC, firstName ASC, lastName ASC";
###

Please help check it.
Thx