Hi all,
i can't find out, how to change default sort column in a Group.
e.g. Menu -- Start -- Windows Computers ... allways sort by IP Adress. would change this to Hostname.
Tryed out to change the SQL Statement "ORDER BY"... didn't work.
in a query.xml you have <report_sort_column>0</report_sort_column>, but in a group.xml you haven't.
[code]<?xml version="1.0" encoding="ISO-8859-1"?> <group> <details> <group_name>Windows Computers</group_name> <group_padded_name></group_padded_name> <group_dynamic_select><![CDATA[SELECT distinct(system.system_id) FROM system WHERE system.man_os_group = 'Windows' AND system.man_status = 'production']]></group_dynamic_select> <group_parent>1</group_parent> <group_description>Any items that have their status attribute set to 'production' and have their os_name attribute containing 'windows'.</group_description> <group_category>os</group_category> <group_icon>windows</group_icon> <group_display_sql><![CDATA[SELECT system.man_icon, system.man_os_family, system.hostname, system.system_id, system.man_ip_address, system.man_manufacturer, system.man_model, system.man_serial, sys_sw_windows.windows_user_name, oa_location.location_name FROM system LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id LEFT JOIN sys_sw_windows ON (system.system_id = sys_sw_windows.system_id AND system.timestamp = sys_sw_windows.timestamp) LEFT JOIN oa_location ON (system.man_location_id = oa_location.location_id) WHERE oa_group_sys.group_id = ?]]></group_display_sql> </details>[/code]
any ideas ?
Cheers Brick
|