/apex-dynamic-action-plugin-translate-ir-report-selector

Oracle Application Express (APEX) dynamic action plugin for translate interactive report and interactive grid saved report selector

Primary LanguageHTMLMIT LicenseMIT

Translate IR/IG Report Selector

Translate the names of Interactive Report and Interactive Grid saved alternative reports using text messages.

Demo available at apex.oracle.com

Usage

System Requirements

  • Oracle Database 19c or later
  • Oracle Application Express version 22.2 or later

Report Name Translation

Translations of report names should be saved in text messages. The name of the text message consists of the prefix IR_REPORT_ALIAS_ or IG_REPORT_ALIAS_, depending on region, and the saved report alias, for example IR_REPORT_ALIAS_345678.

Seed Text Messages

To seed text messages for all Interactive Report and Interactive Grid saved alternative reports in application, run the PL/SQL script seed_text_messages.sql. Then translate created messages with the APEX builder.

Dynamic Action for Interactive Report

  • Event: After Refresh
  • Selection Type: Region
  • Region: select yout interactive report region
    • Action: Translate IR/IG Report Selector [Plug-In]
    • Fire on Initialization: On

Dynamic Action for Interactive Grid

  • Event: Page Load
    • Action: Translate IR/IG Report Selector [Plug-In]
    • Selection Type: Region
    • Region: select yout interactive grid region

Known Issues

Interactive grid report name translations are fetch always from database. It causes a delay before the selector report names change. As a result, users will see the original report names for a short time.

License

This code is released under MIT license by Jari Laine.