Hi,
erst einmal Danke für die Anleitung! Ich bin bis jetzt mit dem Report Manager noch nicht so ganz klar gekomen, aber jetzt komm ich langsam dahinter wie dieser funktioniert.
Ich habe versucht den Report in unserem i-doit 1.7.1 nachzumachen. Leider bekomme ich beim Prüfen folgenden Fehler sobald ich das Attribut "Verbunden mit Anschluss (Verkabelung > Anschlüsse)" einfüge, egal welche Unterattribute ich auswähle.
Ein Fehler ist aufgetreten: Database error : Query error: 'SELECT obj_main.isys_obj__id AS 'id', obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###1', j4.isys_catg_connector_list__title AS 'LC__CMDB__CATG__TITLE###50', j3.isys_connection_type__title AS 'LC__CATG__CONNECTOR__CONNECTION_TYPE###50', j13.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CMDB__OBJTYPE__CABLE###1', j9.isys_obj__id AS 'isys_cmdb_dao_category_g_cable::dynamic_property_callback_connection::isys_obj__id::LC__CATS__CABLE__CONNECTION#LC__CMDB__OBJTYPE__CABLE###151', j16.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CATG__CONNECTOR__ASSIGNED_CONNECTOR###1' FROM isys_obj AS obj_main INNER JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id LEFT JOIN isys_catg_connector_list AS j6 ON j6.isys_catg_connector_list__isys_obj__id = obj_main.isys_obj__id AND j6.isys_catg_connector_list__assigned_category = 'C__CATG__CONNECTOR' LEFT JOIN isys_catg_connector_list AS j1 ON j1.isys_catg_connector_list__isys_obj__id = obj_main.isys_obj__id LEFT JOIN isys_connection_type AS j3 ON j3.isys_connection_type__id = j1.isys_catg_connector_list__isys_connection_type__id LEFT JOIN isys_catg_connector_list AS j4 ON j4.isys_catg_connector_list__isys_cable_connection__id = j6.isys_catg_connector_list__isys_cable_connection__id AND j4.isys_catg_connector_list__id != j6.isys_catg_connector_list__id LEFT JOIN isys_cable_connection AS j7 ON j7.isys_cable_connection__id = j4.isys_catg_connector_list__isys_cable_connection__id LEFT JOIN isys_obj AS j9 ON j9.isys_obj__id = j7.isys_cable_connection__isys_obj__id LEFT JOIN isys_obj AS j13 ON j13.isys_obj__id = j9.isys_obj__id LEFT JOIN isys_catg_cable_list AS j14 ON j14.isys_catg_cable_list__isys_obj__id = j9.isys_obj__id LEFT JOIN isys_obj AS j15 ON j15.isys_obj__id = j9.isys_obj__id LEFT JOIN isys_obj AS j16 ON j16.isys_obj__id = j1.isys_obj__id LEFT JOIN isys_obj_type AS j18 ON j18.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id WHERE TRUE AND ( (j1.isys_catg_connector_list__title LIKE '%OUT%' ) ) AND ( (j18.isys_obj_type__id = '43' ) ) LIMIT 0, 25;': Unknown column 'j1.isys_obj__id' in 'on clause' .
Mit dem Fehler kann ich nicht viel anfangen, da ich kein ITler bin. Funktioniert der Report unter der Version 1.7.1 nicht?
Gruß Moritz