Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Users
    • Search

    Attribute für Report nicht verfügbar

    Allgemein
    2
    4
    1888
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • B
      Barracuda last edited by

      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

      1 Reply Last reply Reply Quote 0
      • J
        jkondek i-doit Kenner last edited by

        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

        1 Reply Last reply Reply Quote 0
        • B
          Barracuda last edited by

          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

          1 Reply Last reply Reply Quote 0
          • J
            jkondek i-doit Kenner last edited by

            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

            1 Reply Last reply Reply Quote 0
            • First post
              Last post