Clarity PPM

Expand all | Collapse all

Attributes tables

  • 1.  Attributes tables

    Posted 10-15-2018 07:02 AM

    Hello team.

    I need a query to the database that shows me the attributes that are included in the data warehouse (custom attributes and stock attributes, all). I have this query:

     

    SELECT DISTINCT
    meta.object_code,
    obj.name Objeto,
    meta.attribute_code cod_atributo,
    meta.dwh_table_name tabla_dwh,
    meta.dwh_column_name columna_dwh,
    decode(meta.is_custom,'0','No','1','Sí') personalizado
    FROM
    dwh_meta_columns meta
    INNER JOIN
    ODF_OBJECTS_V obj ON obj.code = meta.object_code AND obj.language_code = 'es'
    ORDER BY
    Object_code, meta.attribute_code

     

    Result:

     

    I can not show the "name" of the attribute:

     

    Anyone know what table I can get it?

     

    Thank you very much in advance.



  • 2.  Re: Attributes tables

    Posted 11-09-2018 05:14 PM

    You need to join with the CMN_CAPTIONS_NLS table to get the name. Don't forget to specify the language value ('en' if you want english) to keep your result set under control.