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

    Report: Anzeigen des Objektnamens anstatt Objekt-ID

    Scheduled Pinned Locked Moved Betrieb
    13 Posts 2 Posters 421 Views 1 Watching
    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.
    • F Offline
      FlatErik @MartinV
      last edited by

      @martinv
      Danke! Leider wird mir weiterhin nur die Objekt-ID angezeigt.

      Folgende Abfrage habe ich jetzt:

      SELECT 
      obj_main.isys_obj__id AS '__id__', 
      j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
      j2.isys_cats_lic_list__isys_obj__id AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
      
       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_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS j4 ON j4.isys_obj__title = j2.isys_cats_lic_list__isys_obj__id 
      LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
      LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
      LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
      
      WHERE TRUE 
       AND  ( (job9.isys_obj__id = '4272901' ) )
       ORDER BY j7.isys_cats_person_list__last_name ASC
      

      Hättest du noch eine Idee?

      Vielen Dank!

      MartinVM 1 Reply Last reply Reply Quote 0
      • MartinVM Offline
        MartinV @FlatErik
        last edited by MartinV

        Du darfst nicht in der JOIN-Clause den j4.isys_obj__id durch j4.isys_obj__title ersetzen, sondern hinter SELECT den j2.isys_cats_lic_list__isys_obj__id .

        F 2 Replies Last reply Reply Quote 0
        • F Offline
          FlatErik @MartinV
          last edited by

          @martinv Super Danke es hat geklappt!

          F 1 Reply Last reply Reply Quote 0
          • F Offline
            FlatErik @MartinV
            last edited by

            @martinv Ist es im idoit möglich, die Abfrage auch dahingehend zu ändern, dass man sich die Anzahl der unterschiedlichen Lizenzen anzeigen lassen kann? Ich hab es mit group by probiert aber leier klappt es nicht..

            MartinVM 1 Reply Last reply Reply Quote 0
            • MartinVM Offline
              MartinV @FlatErik
              last edited by

              Ich bin jetzt nicht der große Datenbank-Entwickler, aber in etwa mit

              SELECT
              COUNT(obj_main.isys_obj__id) AS 'Anzahl',
              j4.isys_obj__title AS 'Lizenz'
              
              FROM ...
              
              WHERE ...
              
              GROUP BY j4.isys_obj__title
              

              sollte es gehen. Die ORDER BY-Clause kannst Du dann weglassen (und wenn nicht, muss sie nach der GROUP BY-Clause stehen).

              F 1 Reply Last reply Reply Quote 0
              • F Offline
                FlatErik @MartinV
                last edited by

                @martinv
                Hat auf anhieb leider nicht geklappt. Ich werde es weiter versuchen. Vielen Dank erstmal!

                1 Reply Last reply Reply Quote 0
                • F Offline
                  FlatErik @FlatErik
                  last edited by

                  @flaterik Hallo Martin!

                  Sehr seltsam: die Abfrage funktioniert seit heute auf einmal nicht mehr.
                  Im "Report-Vorschau" klappt es, aber im normalen Report zeigt er nichts an.
                  Auch haben sich die "Treffer" im Report von ca. 150 auf 100011 vervielfacht.

                  Woran könnte das liegen?

                  13.png

                  12.png

                  F 1 Reply Last reply Reply Quote 0
                  • F Offline
                    FlatErik @FlatErik
                    last edited by

                    Die nicht von uns geänderte Abfrage funktioniert:

                    SELECT 
                    obj_main.isys_obj__id AS '__id__', 
                    j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
                    j2.isys_cats_lic_list__isys_obj__id AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
                    
                     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_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
                    LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
                    LEFT JOIN isys_obj AS j4 ON j4.isys_obj__id = j2.isys_cats_lic_list__isys_obj__id 
                    LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
                    LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
                    LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
                    
                    WHERE TRUE 
                     AND  ( (job9.isys_obj__id = '4272901' ) )
                     ORDER BY j7.isys_cats_person_list__last_name ASC
                    
                    

                    Die bearbeitete nicht:

                    SELECT 
                    obj_main.isys_obj__id AS '__id__', 
                    j7.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
                    j4.isys_obj__title AS 'LC__CMDB__CATG__LIC_ASSIGN__LICENSE###0_12' 
                    
                     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_application_list AS j5 ON j5.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id  
                    LEFT JOIN isys_cats_lic_list AS j2 ON j2.isys_cats_lic_list__id = j5.isys_catg_application_list__isys_cats_lic_list__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
                    LEFT JOIN isys_obj AS j4 ON j4.isys_obj__id = j2.isys_cats_lic_list__isys_obj__id 
                    LEFT JOIN isys_cats_person_list AS j7 ON j7.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
                    LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j5.isys_catg_application_list__isys_connection__id AND (j5.isys_catg_application_list__isys_catg_application_priority__id IS NULL OR j5.isys_catg_application_list__isys_catg_application_priority__id = 2) 
                    LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
                    
                    WHERE TRUE 
                     AND  ( (job9.isys_obj__id = '4272901' ) )
                     ORDER BY j7.isys_cats_person_list__last_name ASC
                    
                    F 1 Reply Last reply Reply Quote 0
                    • F Offline
                      FlatErik @FlatErik
                      last edited by

                      @MartinV der Download als CSV funktioniert und ist fehlerfrei- die Anzeige im Browser aber nicht. Habe es auch schon mit verschiedenen Browsern versucht.

                      MartinVM 1 Reply Last reply Reply Quote 0
                      • MartinVM Offline
                        MartinV @FlatErik
                        last edited by

                        Nee, tut mir leid, da bin ich raus.
                        Aber gut, dass wenigstens der Export funktioniert.

                        F 1 Reply Last reply Reply Quote 0
                        • F Offline
                          FlatErik @MartinV
                          last edited by

                          @martinv ja! das ist die Hauptsache 🙂 Danke trotzdem!

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