commit b302eba925a06bfe3155b5c24501b6a5de48ecce sort supernet subnets by IP diff --git a/src/classes/cmdb/dao/category/global/isys_cmdb_dao_category_g_virtual_supernet.class.php b/src/classes/cmdb/dao/category/global/isys_cmdb_dao_category_g_virtual_supernet.class.php index 0afd27f..c3e5ef3 100755 --- a/src/classes/cmdb/dao/category/global/isys_cmdb_dao_category_g_virtual_supernet.class.php +++ b/src/classes/cmdb/dao/category/global/isys_cmdb_dao_category_g_virtual_supernet.class.php @@ -43,7 +43,8 @@ class isys_cmdb_dao_category_g_virtual_supernet extends isys_cmdb_dao_category_g 'isys_cats_net_list__address_range_from_long >= \''.$p_from_long.'\' '. 'AND '. 'isys_cats_net_list__address_range_to_long <= \''.$p_to_long.'\''. - ') AND isys_obj__id != '.(int) $p_obj_id.' AND isys_obj__status = ' . (int) $p_status; + ') AND isys_obj__id != '.(int) $p_obj_id.' AND isys_obj__status = ' . (int) $p_status . ' '. + 'ORDER BY isys_cats_net_list__address_range_from_long'; return $this->retrieve($l_sql); }