Wednesday, June 16, 2010

Special columns for APEX Standard Reports


I was testing APEX 4.0 on http://apex.oracle.com and I noticed that on Standard Reports you can add 2 types of "special" columns: Derived Column and Column Link. At first I thought this was a new APEX 4.0 feature, but then tested on a copy of 3.x noticed it was there as well! I apologize if this is old news to people but I found it to be a pretty neat feature.

The interesting thing about these columns is that you can add Derived Column and Column Link columns and it does not modify your existing SQL.

The only difference I can tell about these 2 column types is that Derived Columns don't contain the following attributes: List of Values, Tabular Form Attributes, and Column Link

3 comments:

  1. What is a "Derived Column"? What can I do with one?

    ReplyDelete
    Replies
    1. It appears to be a column that you can add a column which you just edit the HTML content of the column. I'll try to blog about it soon.

      Delete
    2. See http://www.talkapex.com/2014/01/derived-columns.html for more detailed follow up.

      Delete