2 answers
- 10-1
Bad group definition for Duplicate UUIDs. New definition attached. Delete old group and IMPORT this new group.
- Rajat Malik
After importing the attached xml problem has been resolved
Add your comment... - 10-1
There is no group titled "Laptops and Notebooks". Suggest you delete this group and ACTIVATE the Laptops group. Just tested this group and it works as intended.
- Rajat Malik
I have add this group "Laptops and Notebooks" base on form_factor so may be the issue is with the xml i have added.
- Rajat Malik
This is the XML I am using to group Laptop and Notebooks for your reference <?xml version="1.0" encoding="ISO-8859-1"?> <group> <details> <group_name>Laptops & Notebooks</group_name> <group_padded_name></group_padded_name> <group_dynamic_select><![CDATA[SELECT distinct(system.id) FROM system WHERE system.form_factor = 'Laptop' OR system.form_factor = 'Notebook' AND system.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 Form_factor attribute set to 'laptop or notebook'</group_description> <group_category>device</group_category> <group_display_sql><![CDATA[SELECT system.id, system.hostname, system.description, system.ip, system.type, system.os_family, system.os_name, system.icon FROM system, oa_group_sys WHERE system.id = oa_group_sys.system_id AND oa_group_sys.group_id = ? AND system.status = 'production' GROUP BY system.id]]></group_display_sql> <group_icon>device</group_icon> <total>42</total> </details> <columns> <column> <id>106</id> <column_order>1</column_order> <column_name>Icon</column_name> <column_variable>icon</column_variable> <column_type>image</column_type> <column_link></column_link> <column_secondary>os_family</column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> <column> <id>107</id> <column_order>2</column_order> <column_name>Hostname</column_name> <column_variable>hostname</column_variable> <column_type>link</column_type> <column_link>/main/system_display/</column_link> <column_secondary>system_id</column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <id>108</id> <column_order>3</column_order> <column_name>IP Address</column_name> <column_variable>ip</column_variable> <column_type>ip_address</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <id>109</id> <column_order>4</column_order> <column_name>Type</column_name> <column_variable>type</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <id>110</id> <column_order>5</column_order> <column_name>Description</column_name> <column_variable>description</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <id>111</id> <column_order>6</column_order> <column_name>OS / Device</column_name> <column_variable>os_name</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>left</column_align> </column> <column> <id>112</id> <column_order>7</column_order> <column_name>Tags</column_name> <column_variable>tag</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> </columns> </group>
- Mark Unwin
In your group_display_sql you need to request full table.column name like {code} SELECT system.id AS `system.id`, system.name AS `system.name`... etc {code} And in your column definitions you need to use these full table.column names (ie, system.id, not just id).
- Rajat Malik
Thanks Mark!!!
Add your comment...
I am getting below error when list some groups like:
Duplicate UUIDs
A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$id
Filename: theme-tango/v_report.php
Line Number: 114
Laptops & Notebooks
A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$system.id
Filename: theme-tango/v_report.php
Line Number: 127
It will show the results at bottom if the page but shows these multiple error on the top.
Please help me to fix this.