1 Reply Latest reply: Aug 26, 2013 12:13 PM by Ron M-Oracle RSS

    How to Query the Summary Name from Custom Section Row Header Information

    YokoV

      I need a query that can help me retrieve the summary name from a custom section row header information.  We have a couple of Denorm tables that when the data is denormalized, the row_name field is only showing the denormalized alias name.  We would like to be able to pull the summary name from the row header information section?  How can we use the denorm alias name and join it to another table to find the associated summary name?

        • 1. Re: How to Query the Summary Name from Custom Section Row Header Information
          Ron M-Oracle

          The following query returns the row name as well as the denorm row name, for a given custom section, where we specify the custom section by the denorm table. You oculd do this in other ways, it just depends on how you want to retrieve the information. Is this what you are looking for?

           

          SELECT ml.Name [rowName], ml.langID, dr.NAME [denormRowName], dr.FKROWTEMPLATE, dt.GENERATED_TABLE_NAME

          FROM DENORM_CS_ROW dr

          inner join DENORM_CS_TABLE dt on dr.FK_DENORM_TABLE_ID = dt.ID

          inner join commonextendedattributeml ml on dr.FKROWTEMPLATE = ml.fkOwner

          where dt.NAME = 'myDenormTableName'