Skip to Main Content

APEX

Announcement

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.

redirect to page

Chandler BingNov 29 2019 — edited Dec 3 2019

I have form ,and there is a button that performs to redirect another page in the same application and pass value. for example, as shown below. but the problem is value should be shown null.

I don't want this on a branch, bcoz i am dont want to submit page.

pastedImage_0.png

plz give any suggestion ?

This post has been answered by Veerendra Patil on Nov 29 2019
Jump to Answer

Comments

jariola

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

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
image.pngMy 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

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

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 
image.png

Awais Majeed

image.png@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

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

Soukaina IDRISSI

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
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

Marked as Answer by Soukaina IDRISSI · Sep 23 2021
Soukaina IDRISSI

Yeah, it works. but the but the language is not in French.
Where can i specify it ?

jariola

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.

Soukaina IDRISSI

Ah, yes you are right, thank you very much for your help.

Soukaina IDRISSI

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?

jariola

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.

Soukaina IDRISSI

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?

jariola

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.

Soukaina IDRISSI

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 ?

jariola

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.

Soukaina IDRISSI

if I replace all IR with IG in the plugin source code, will it work ?

jariola

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.

jariola

I think managed add some kind support also for IG.
Take new version from GitHub and see also README.md for instructions

Soukaina IDRISSI

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
image.pngAnd for IG, i didn't have the section Saved Reports, like on your project
image.png

jariola

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?

Soukaina IDRISSI

Yes, i created an alternative IG, but i dont have the Saved Report section in IG

jariola

And that saved alternative report isn't private?

Soukaina IDRISSI

no they are publics

1 - 25

Post Details

Added on Nov 29 2019
3 comments
170 views