Forum Stats

  • 3,769,708 Users
  • 2,253,013 Discussions
  • 7,875,157 Comments

Discussions

How can i translate the alternative saved report

Soukaina IDRISSI
Soukaina IDRISSI Member Posts: 848 Blue Ribbon

Hi Experts,

Im using APEX20.1 and i want to show the name of saved report depending of the selected langage.

I'm talking about this part.

I was able to translate the Primary Report, via Shared Components -> Text Messages

On the other hand, for the other saved reports, I don't know how I could translate them.

Thank you for help in advances.

Tagged:

Best Answer

  • jariola
    jariola Member Posts: 10,459 Silver Crown
    edited Sep 23, 2021 10:07AM Accepted Answer

    Problems that I did fix.

    • I restore component setting "Translate IR Report Selector" to default value "IR_REPORT_ALIAS_"
    • In dynamic action Fire on Initialization need to be On
    • In IR attributes Reports Select List need to be On

    After all is set correctly you need republish translated application

    Soukaina IDRISSI
«13

Answers

  • jariola
    jariola Member Posts: 10,459 Silver Crown
    edited Jan 14, 2021 11:53AM

    I don't know is there is out of box feature for that. But you can create custom table where is report alias and your translations. Join custom table to APEX_APPLICATION_PAGE_IR_RPT and create LOV. Then create select list for LOV and use that item in IR attribute Report ID item

    Report ID Item

    Select a page or application item whose value stores the saved report ID. Interactive report uses this item value to link to a saved report. For example, you can define list of saved reports with links with defined item name and saved report ID as its value to link to a saved default reports, public or private reports. The saved report IDs can be retrieved from the APEX_APPLICATION_PAGE_IR_RPT view.

  • Soukaina IDRISSI
    Soukaina IDRISSI Member Posts: 848 Blue Ribbon

    Hi Jariola,

    Thank you for reply.

    So, as you said, i created a:

    1. Custom table that i named 'TRANSLATION_REPORT_TBL', which I have linked to APEX_APPLICATION_PAGE_IR_RPT, in the list of values: LOV_SAVED_REPORT.
    2. In my Page 5, I created an Item: P5_LIST_SAVED_REPORT whose type is Select list based on my created LOV
    3. I used this item in REPORT ID of as below

    My issue here is:

    The default select list of the IR is not changed when i switch between languages. 

    You can see all this details, on apex.oracle.com with this credentials:

    Workspace: ws_formation

    Username: asoukaina

    Password: azerty12345

    I used the Application 24503 - Custom_IR / Page 5 - Saved Report = 24503:5

    Thank you for help.

  • jariola
    jariola Member Posts: 10,459 Silver Crown

    As I said, there isn't way to translate IR reports select list values. You need use custom select list.

    I changed your example and hide IR reports select list, corrected LOV query and changed P5_LIST_SAVED_REPORT attributes. See now your example.

  • Soukaina IDRISSI
    Soukaina IDRISSI Member Posts: 848 Blue Ribbon

    Hi Jariola,

    thank you for your response.

    So, How can I place the select list after the button 'Actions' ?

    I did some code in page load:

    $('#sr_region_toolbar').append($('#P5_LIST_SAVED_REPORT_CONTAINER')); // to set position
    $('#P5_LIST_SAVED_REPORT_LABEL').css('display', 'block'); // make item label as block
    $('#P5_LIST_SAVED_REPORT_LABEL').css('white-space', 'nowrap'); // disable wrapping
    

    But the result was not what was expected 


  • Awais Majeed
    Awais Majeed Member Posts: 111 Bronze Badge

    @Soukaina IDRISSI I think we can translate save report text I just change your lov query and I removed decode.in your case issue with browser value. Try to set language value in page item or application item then use in decode.

  • jariola
    jariola Member Posts: 10,459 Silver Crown

    Just for exprementing, I created plug-in that could be useful. You can find it from GitHub.

    Sven W.
  • Soukaina IDRISSI
    Soukaina IDRISSI Member Posts: 848 Blue Ribbon

    Thank you Jariola for this plugin.

    But I couldn't turn it on.

    Could take a look at my application , on apex.oracle.com with this credentials:

    Workspace: ws_formation

    Username: asoukaina

    Password: azerty12345

    I used the Application 24503 - Custom_IR / Page 5 - Saved Report = 24503:5

  • jariola
    jariola Member Posts: 10,459 Silver Crown
    edited Sep 23, 2021 10:07AM Accepted Answer

    Problems that I did fix.

    • I restore component setting "Translate IR Report Selector" to default value "IR_REPORT_ALIAS_"
    • In dynamic action Fire on Initialization need to be On
    • In IR attributes Reports Select List need to be On

    After all is set correctly you need republish translated application

    Soukaina IDRISSI
  • Soukaina IDRISSI
    Soukaina IDRISSI Member Posts: 848 Blue Ribbon

    Yeah, it works. but the but the language is not in French.

    Where can i specify it ?

  • jariola
    jariola Member Posts: 10,459 Silver Crown

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