hi jkondek,

hast du da zufällig den ganzen SQL string bei der hand, den ich da einfügen muss?

dass wär mein momentaner code:

SELECT
obj_main.isys_obj__id AS 'id',
(CASE obj_main.isys_obj__status WHEN 1 THEN 'LC__CMDB__RECORD_STATUS__BIRTH' WHEN 2 THEN 'LC__CMDB__RECORD_STATUS__NORMAL' WHEN 3 THEN 'LC__CMDB__RECORD_STATUS__ARCHIVED' WHEN 4 THEN 'LC__CMDB__RECORD_STATUS__DELETED' END) AS 'LC__UNIVERSAL__CONDITION' ,
jn1.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###1',
j3.isys_obj__title AS 'LC__CMDB__CATG__LOCATION###26'

FROM isys_obj AS obj_main
LEFT 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_obj_type AS jn1 ON jn1.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id
LEFT JOIN isys_catg_location_list AS loc  ON loc.isys_catg_location_list__isys_obj__id = obj_main.isys_obj__id
LEFT JOIN isys_obj AS j3 ON loc.isys_catg_location_list__parentid = j3.isys_obj__id

WHERE TRUE
AND obj_main.isys_obj__status = 2;

gruss

Hallo,

ich bräuchte einen Report mit den Attributen "Object ID" unter "General" und "Description" unter "Location".

Leider lassen sich diese im Query Builder nicht auswählen.

Hat irgendjemand eine Lösunge?

Danke im Vorraus