3 Replies Latest reply on May 13, 2014 11:42 AM by Marcos Vainer Loeff

    Request with AF Category criteria with PI SQL commander AF database

    paory

      Hello guys,

       

      I will request with AF category element criteria the AF database with PI SQL commander.

       

      But i didn't found any PI SQL command about this.

       

      Have you idea about this?

       

      Regards

       

       

       

       

       

       

       

       

        • Re: Request with AF Category criteria with PI SQL commander AF database
          Roger Palmen

          Could you explain your question a bit more? I don't yet understand your question fully.

            • Re: Request with AF Category criteria with PI SQL commander AF database
              xwang

              Hi,

               

              Do you wish to find the your defined PI AF Element categories from one PI AF database via PI SQL conmmander please?  If so, please use the PI SQL commander to link the PI AF database which you want.  Then, you could see a table, named "Category", under "Asset -> Tables".  This table is used to store all categories you defined.

               

              Xi Wang

               

              vCampus team

                • Re: Request with AF Category criteria with PI SQL commander AF database
                  Marcos Vainer Loeff

                  Hello Paory,

                   

                  If you search this information on the PI OLEDB Enterprise Users Guide, you will find:

                   

                  “Elements, element attributes, element templates, and element template attributes can be placed into one or more categories, which helps with organization and searching. Categorization is captured by ElementCategory, ElementAttributeCategory, ElementTemplateCategory, and ElementTemplateAttributeCategory tables which refer to the global category table as well as to the element, element attribute, element template, and element template attribute tables (M-N relationship decompositions).”

                   

                  Hence, all categories are stored on the Category table as Xi has already pointed out. Nevertheless, for instance, the ElementAttributeCategory table which has two columns (CategoryID and ElementAttributeID) is the table responsible for linking an ElementAttribute with its proper category.

                   

                  Hope this helps!!