Attribute für Report nicht verfügbar



  • 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


  • i-doit Kenner

    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



  • 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


  • i-doit Kenner

    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


 


Datenschutz / Privacy Policy