#4177 [HHQ-4029] Sorting issue with serviceDAO method findByPlatfo

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-4029
The method findByPlatform_orderName() in ServiceDAO has sorting based on server name and I believe it should sort based on service name.

public Collection<Service> findByPlatform_orderName(Integer id, boolean asc) {


        String sql = "select sv from Service sv " + " join fetch sv.server s " +


                     " join fetch s.platform p " + "where p.id=?" +


                     "order by s.resource.sortName " + (asc ? "asc" : "desc");


        return createQuery(sql).setInteger(0, id.intValue()).list();


    }