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

    Featurewunsch: Ansicht in Objekt: 'Objekt von'

    Scheduled Pinned Locked Moved Entwicklung
    3 Posts 2 Posters 909 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.
    • K Offline
      kingofmyfloh
      last edited by

      Hallo,

      ich habe leider keine Möglichkeit in dem Objekt zu sehen, zu welchen Gruppe
      oder jetzt auch IT-Services es gehört.
      Dies wäre allerdings schön 🙂

      so in etwa:

      SELECT
       g.isys_obj__id AS gID,
       g.isys_obj__title AS 'group'
      FROM isys_obj a
       JOIN isys_connection ON (isys_connection__isys_obj__id = a.isys_obj__id)
       JOIN isys_cats_group_list ON ( isys_connection__id = isys_cats_group_list__isys_connection__id)
       JOIN isys_obj g ON ( isys_cats_group_list__isys_obj__id = g.isys_obj__id )
      WHERE a.isys_obj__id = <id>;</id> 
      
      1 Reply Last reply Reply Quote 0
      • D Offline
        dbluemer
        last edited by

        Eine entsprechende virtuelle Kategorie wird es in naher Zukunft geben.

        1 Reply Last reply Reply Quote 0
        • K Offline
          kingofmyfloh
          last edited by

          klingt gut, danke 🙂

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