Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
There are several queries that fail with errors like:
Caused by: java.sql.SQLSyntaxErrorException: invalid ORDER BY expression in statement [select count(attributea1_.id) as col_0_0_ from grouper_groups group0_ cross join grouper_attribute_assign attributea1_ cross join grouper_attribute_def_name attributed2_ cross join grouper_attribute_def attributed3_ cross join grouper_memberships_all_v membership4_ cross join grouper_memberships_all_v membership5_ where membership5_.owner_group_id=group0_.id and (membership5_.field_id in (? , ?)) and (membership5_.member_id in (? , ?)) and membership5_.immediate_mship_enabled='T' and attributea1_.attribute_def_name_id=attributed2_.id and group0_.id=attributea1_.owner_group_id and attributed3_.id=attributed2_.attribute_def_id and attributea1_.attribute_assign_type='group' and membership4_.owner_attr_def_id=attributed2_.attribute_def_id and (membership4_.field_id in (? , ?)) and (membership4_.member_id in (? , ?)) and membership4_.immediate_mship_enabled='T' and attributea1_.enabled='T' and (attributed2_.id in (?)) order by group0_.display_name asc]