Main Region

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

LS
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

f?p=&APP_ID.:106:&SESSION.::::P106_PRODUCT_ID:#PRODUCT_ID#

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

7 comments

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

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

Please create a test case on demo.tryfoexnow.com 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

LS
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:- http://demo.tryfoexnow.com/apex/f?p=173:1 Thanks in Advance, Anu

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

if you wish to access column information passed through as parameters to dynamic actions this.data 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.

LS
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 :(

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

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

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

Thanks Matt for confirmation!!

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

f?p=&APP_ID.:106:&SESSION.::::P106_PRODUCT_ID:#P105_PRODUCT_ID#

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

0 comments

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