2 Replies Latest reply on Jun 6, 2017 12:02 AM by ahmee

    Understanding links and the green objects shown in SWQL Studio

    ahmee

      Hi

       

      I am trying to understand the what the links shown in any table represent in swql studio. In the following snapshot the link with Storage Array makes sense to me as there is Storage Array ID object in the table linking this table to storage array table. The other link is Orion.srm.pools, not sure how this is linked. There are some pool capacity objects but there is no object for pool id in this table. Also i wondering what does the green objects represent?

       

       

       

      Regards

      Ahmee

        • Re: Understanding links and the green objects shown in SWQL Studio
          tdanner

          The green blocks represent inherited properties. The root type of the SWIS entity type hierarchy is System.Entity. It defines a few properties - DisplayName, Description, InstanceSiteId, InstanceType, and Uri - so all SWIS entity types will have those (because of how SWQL Studio builds that tree, an inherited property will have a blue block icon and be grouped with the non-inherited properties if the entity type has redeclared it for whatever reason).

           

          The chain link icon marks Navigation Properties, which are a shortcut to a join. This can either be a simple foreign key join (like your StorageArrayID example) or a join through a mapping table for many-to-many relationships.

          1 of 1 people found this helpful
          • Re: Understanding links and the green objects shown in SWQL Studio
            ahmee

            Thanks for the answer. It all makes sense now.