LPS-46246

Hey Hugo,

One thing I wanted to mention was the SQL change in https://github.com/jonathanmccann/liferay-portal/commit/c17180950c2059e35b8cb7378460386e22340c84 I talked to a handful of TS and none of us knew the correct way to format it. The issue is that the GroupNameComparator uses "groupName" in the order by clause, so an alias is needed to map "groupName" to "name". Also, I didn't deprecate the methods in the GroupFinderImpl because it doesn't seem like anyone previously deprecated the methods when they changed the parameters. Let me know if you have any questions.

Thanks.