For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Say for eg: my data is like this
--order by col3 col1 col2 col3 1 5 1 1 10 2 2 2 3 2 5 4 1 15 5 I hav to get o/p as col1 sum_col2 1 15 2 7 1 15 I have to group by preserving the order Pls give me suggestions.. jeneesh
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.
APEX_APPLICATION_PAGE_IR_RPT
Hi Jariola, Thank you for reply. So, as you said, i created a: 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. In my Page 5, I created an Item: P5_LIST_SAVED_REPORT whose type is Select list based on my created LOV 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.
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.
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
@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.
Just for exprementing, I created plug-in that could be useful. You can find it from GitHub.
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
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
Yeah, it works. but the but the language is not in French. Where can i specify it ?
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.
Ah, yes you are right, thank you very much for your help.
Hi Jariola, I have a little problem with the plugin. In my development space because I am on version 20.1 of Apex. Will there be a way to use this plugin with this version?
I think you can't just import plugin to older version of APEX But workaround, you can check plugin source and just recreate it from scratch in your environment. I know it's not optimal way.
You mean I have to change line 17 of the plugin source code :
,p_release=> '21.1.2'
by my own version
,p_release=> '20.1.0'
Is this right?
I don't know does that work. I did mean that you just edit plugin in apex.oracle.com and see how it is done. Create new plugin to your environment with exactly same settings and code. I think plugin is quite simple so it will not take more that 5min to recreate it from scratch.
Ok, i see now what you mean. Yeah , I just tested, and it works. If I understand correctly, this solution only concerns the IR, and not the IG ?
Plugin works only for IR. I assume it shouldn't be so hard make changes that plugin works for IG . Or create new similar plugin for IG. Unfortunately I don't have time to check.
if I replace all IR with IG in the plugin source code, will it work ?
I really don't know because haven't test that. I don't see it make any harm if you can test it. But I assume something more is needed for JavaScript function that actually do changes to report select list. If you succeed get it working for IG, please contribute changes on GitHub via pull request.
I think managed add some kind support also for IG. Take new version from GitHub and see also README.md for instructions
Hi Jariola, Thanks for the new version of the plugin including IG. Im using APEX 20.1, and I had some differences with your project example, like as: Concerning IR: i get part settings And for IG, i didn't have the section Saved Reports, like on your project
Plug-in is only available for APEX 21.1. It seems you have set wrong scope for plug-in attributes when recreating it to your APEX version. In original plug-in code, attributes scope is Application. I don't have access to APEX 20.1. Have you saved any alternative IG report?
Yes, i created an alternative IG, but i dont have the Saved Report section in IG
And that saved alternative report isn't private?
no they are publics