1 Reply Latest reply: Aug 19, 2013 8:11 AM by Ron M-Oracle RSS

    Need to query list of values available for Qualitative EA

    MichaelP_LOL

      I need to provide the attribute Ids, name and the list of the possible values of an Qualitative Extended Attribute:


      I can easily get the id’s and names, but am not seeing the path to the other values

       

      SELECT commonextendedattributetypeml.name,

      commonextendedattributetype.attributetype

        FROM agile.commonextendedattributetype, agile.commonextendedattributetypeml

      WHERE ( (commonextendedattributetypeml.fkextendedattributetype =

      commonextendedattributetype.pkid))

      AND commonextendedattributetypeml.name LIKE '%TM'

      AND commonextendedattributetype.attributetype = 'QUALITATIVE';

        • 1. Re: Need to query list of values available for Qualitative EA
          Ron M-Oracle

          Try the following SQL:

           

          SELECT ml.name,

                 t.attributetype,

                 t.AttributeID,

                 qualML.Quality

            FROM

            commonextendedattributetype t

            INNER JOIN commonextendedattributetypeml ml on ml.fkExtendedAttributeType = t.pkid and ml.langID = 0

            INNER JOIN comExtendedAttrQualityList list on list.fkExtendedAttribute = t.pkid

            INNER JOIN commonExtendedAttributeQuality qual on list.pkid = qual.fkQualityList

            INNER JOIN comExtendedAttributeQualityML qualML on qualML.fkExtendedAttributeQuality = qual.pkid and qualML.langID = 0

          WHERE  

            ml.name LIKE '%TM' AND t.attributetype = 'QUALITATIVE'   

          ORDER BY ml.name  

           

          Note that the above query limits the language id to 0 (for English) in two places