Main Region

Pass column value to another page item
1 answer | 308 views

Nov 28, 2013 03:10 +00:00

Hi FOEX Team,

I have a page having FOEX Grid based on a function returning query( For example Page number-105). On double click of it's row, I have created a Dynamic action to load page 106 in another tab using FOEX Content Loader [Plug-in]. My requirement is to pass a column value i.e. PRODUCT_ID column value to the next page item i.e. P106_PRODUCT_ID which is a hidden item

Open url I used is


But when I check in session, P106_PRODUCT_ID is not populated. Can you please suggest me how to pass the value..


Lata S Nov 28, 2013 04:00 +00:00 

Hi Matt, Thanks for the quick response. I am already using the first method you mentioned. But it is not working for me.... Any suggestions on what can be the reason..

Matt Nolan Nov 28, 2013 04:19 +00:00 

Please create a test case on that reproduces your problem.

Based on your question you are not using the first method I mentioned because the url provided in your question uses a grid column alias #PRODUCT_ID# instead of a page item #P105_PRODUCT_ID# as I describe to use

Lata S Nov 28, 2013 05:03 +00:00 

Hi Matt, Sorry for the mistake, I was changed my url the way you suggested in the first method but still didn't find it working. Please fid the test case here:- Thanks in Advance, Anu

Matt Nolan Nov 28, 2013 05:23 +00:00 

if you wish to access column information passed through as parameters to dynamic actions you must use grid level events like "After Row Select", or "Row Action".

Double click is not a grid event and is a low level DOM event that applies to when you double click anywhere on the grid.

Lata S Nov 28, 2013 05:27 +00:00 

Thanks a lot for clarification.. Is there no way to do it on double click? I don't want to open another tab on row select. My requirement is to open it on Double click :(

Matt Nolan Nov 28, 2013 06:36 +00:00 

Sorry not in v1.2.1 and below, I will log an enhancmeent request.

Lata S Nov 28, 2013 06:47 +00:00 

Thanks Matt for confirmation!!

Nov 28, 2013 03:25 +00:00

Before the content loader action create an additional TRUE action with a lower dsiplay sequence and set a hidden page item on the current page (e.g. P105_PRODUCT_ID) using the "FOEX Grid Row Select Set Item Values". Then use similar syntax in your URL:


Alternatively if you need to support session state protection then add a new column to your report called url and set it's "Display As" setting in the report attributes to hidden. You SQL query should look like:

SELECT apex_util.prepare_url('f?p='|| :APP_ID ||':106:'|| :APP_SESSION ||'::'|| :DEBUG ||'::P106_PRODUCT_ID:'||product_id) url

Then on row selection use the same "FOEX Grid Row Select Set Item Values" dynamic action to set a hidden item called e.g. P105_URL using the grid URL column alias and then use #P105_URL# as the url for the content loader. .....


You must log in or sign up to post questions and answers.