Attribute für Report nicht verfügbar

Barracuda

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

jkondek

Hallo Barracuda,

wenn Du Deine Abfrage ueber den SQL-Editor bearbeitest, muesstest Du im SELECT-Statement fuer die Object ID unter General das Feld isys_obj__id auswaehlen, fuer die Description unter Location das Feld isys_catg_location_list__description.

Hilft Dir das weiter?

Gruss,
jkondek

Barracuda

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

jkondek

Hallo Barracuda,

versuch mal folgende Abfrage:

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' ,
loc.isys_catg_location_list__description AS 'Beschreibung'

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,
jkondek