AnsweredAssumed Answered

Attributes tables

Question asked by CarlosBirlainSelfa82333808 on Oct 15, 2018
Latest reply on Nov 9, 2018 by jason.newman

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.

Outcomes