Oracle APEX - the value does not carry over when using Redirect to Page

1
votes

I have a field on my page that I want to carry over to another page in the application. On a button click I use "Redirect to Page in application" and set the page number to 2.

Now I want to carry over the value P1_MY_ID to page 2, so I used Set Items for target page:

NAME            VALUE
_________       _______
P2_RECORD_ID    &P1_MY_ID.

On Page 2, P2_RECORD_ID is a Select List filled from a shared LOV and its source is set to a database column.

Once page 2 opens, I do not see the value P2_RECORD_ID in a session state. Am I doing something wrong?

2
oracle-apexoracle-apex-5.1
Do you see the item name and value in the URL of the page? If so, this might be a problem with the select list source. – Daniel Frech
Why is that a problem? How can I fix that? – Coding Duchess
I wanted to distinguish if this is a problem with the source or target page, therefore the check in the URL. From your explanation I suspected the target page. I think Jeffreys answer is a good explanation for the possible cause. – Daniel Frech
the second page is a modal dialog, so i cannot check the url... – Coding Duchess
You are able to check that in the network tab of your developer console in Chrome or Firefox. – Daniel Frech

2 Answers

2
votes

Typically if an item has Source Type = Database Column, the Source Used will be "Always, replacing any existing value in session state". This means that on page load the item's value will be overwritten by the Automatic Row Fetch process.

In your particular case, it seems the value you are passing is the record ID - if this is a unique identifier for a record to retrieve from the database, you need to check that it has been set as the Primary Key Item in the automatic row fetch process.

0
votes

Interesting but I just switch places for the items I am passing and it worked... Not sure why it worked but I'll take that...