APEX URL Parser/Builder

Syntax of APEX URL is not easy interpretable, there are many hard to read colon separated values. Peter has great article about this, additionally to Oracle Documentation.

But in APEX there are many places without cool wizard to easy build this complexes URL. To help other developers I build simple APEX URL Builder / Parser, which parse URL to component parts for separate analyze and modifications.  You can of course build your own URL using predefined substitution variables like &APP_ID., &&SESSION_ID. Etc.

APEX URL Builder / Parser

 

Export to Excel from Interactive Reports

Now it is possible to correct export results of Interactive reports to Excel, with correct displaying of strings, number and dates. Excel - export has never been so cool and simple. 

The "GPV Interactive Report to Excel" APEX plugin support now this main features:
•    Correct export of data types (String/Date/Number)
•    Filtering and Sorting
•    Control Break
•    Computations
•    Aggregations
•    Highlighting
•    Auto adjustable Column Width
•    Date/Number Formats
•    Custom downloaded file name (see FAQ)
•    Can be easy implemented for all Interactive reports in application (see FAQ) 

+  New!  Support of substituion variables into SQL-querie of Interactive Report.

This new feature allows you to use different WHERE - clauses with BIND-varables within. See my post that describe use-cases.

See this plugin on GitHub