Service builder incorrectly generates ORDER BY for compound primary keys

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP3 (5.2.7)
• Component/s: Core Infrastructure > Upgrade Framework, Legacy Components > API
• Labels: None
• Environment: All

Service builder does not correctly generate the ORDER BY clause of an SQL query if the tables uses a compound primary key. For example, a table has primary keys, column1, column2, .... The generated method currently sorts by table.column1. However, it should sort by table.id.column1.

UPGRADE NOTE:

To apply this bug fix to custom services, please run Service Builder again in the extension environment and for each portlet that uses Service Builder.