1 Reply Latest reply: Apr 28, 2014 4:14 PM by Mahmoud_Rabie RSS

    Get header for report into plugin

    034b8ffc-1d15-4d41-82ca-e6a65918c0f3

      Hi!

       

      I have plugin, which works with report. But report gets data from "PL\SQL bode returning SQL query". I use  "Use Generic Column Names (parse query at runtime only)" and column name is "COL1, COL2,COL3...", but i want to get database alias and i changed it to my header.

       

      For example, select a.text, a.name from dual .

       

      I know that a.text = 'field1' , a.name ='field2';

       

      field1field2

       

      Maybe i can find alias from query in apex_application_page_rpt_cols  or anywhere else ?