This content has been marked as final. Show 15 replies
Replace is also a pl/sql function.
If the new value needs to be submitted you would need a page item to hold that value.
The computation would then belong to the new item and be
In a procedure it would be
return REPLACE (:P4_LINIE, '-9', '');
If you have apex 4.2 then you can define the new item to be submitted, on the refresh of a region, is a region setting.
:P4_new_item := REPLACE (:P4_LINIE, '-9', '');
Just remember that the value of a page item is always a string.
So something like this will not work
select * from some_table where some_column in(:p4_new_item)
Hmm. I have a few ideas, as well.
Do you want the value of :P4_LINIE actually changed to the new value without the "-9:" on page 4 or do you just want the new/changed value available to the new page?
(Related question) Do you want the computation to happen before page 4 is displayed or just before transferring to the new page?
Do you have a Submit button to get to the next page; what's the mechanism for transferring to the new page?
There are two (or more) ways to do this.
-- 1) Merely reference/use :P4_LINIE on the new page? But I think we have to ensure :P4_LINIE is saved in the session state for this to work.
-- 2) Pass :P4_LINIE to :Px_LINIE on the transfer to page x.
But I need to know how you (want to) transfer to the new page.
I need to transfer the selected items so I can use them in a "select into" query.
-9 is the "all selector" and should be cut if "all" is selected.
If I continue to the next page the value selected should be used in an interactive report via URL.
So my URL should not be like :
I am close now. If i try a computation return colon seperated values
The URL now cuts the -9 BUT the values in the URL are still shown as
Select distinct TEST from TESTSTABLE where TEST in (SELECT TEST FROM TESTTABLE WHERE INSTR ( ',' || TRANSLATE (REPLACE (:P35_TEST, '-9', ''), ':', ',') || ',', ','||TEST||',') > 0)
TEST1:TEST2 not as TEST1,TEST2
Let's try this again:
This assumes you set up a button to do the transfer:
Under Action When Button Clicked, select "Page in this Application", and put Page 35.
Under "Set These Items" put P35_LINIE (Note: No colons, ampersands, or periods in the item name here.)
Under "With These Values" put &P4_LINIE. (Note: use & and . here.)
I shy away from coding parameters -- all but the simplest cases -- in URLs.
Yes. The final thing should be an interactive report with many variables in the url.
Thats the only way to save the IR. So the variables are set as IR-Filters.
Because of that, the URL should hold all variables with a ",".
I have already tried to reference the variables and this works. But I need them in my URL.
You mean like [url http://apex.oracle.com/pls/apex/f?p=VANBAREN_FORUM_TRY_OUT:CHECKBOX1&c=VANBAREN]this.
This method uses a hidden item to store the string with comma's.
A computation that replaces the *:* with *,* in the checkbox item and sets the result in the hidden item.
And a branch that sets the items on the recivieving page and submits the hidden item.
Try out the [url http://apex.oracle.com/pls/apex/f?p=VANBAREN_FORUM_TRY_OUT:CHECKBOX1&c=VANBAREN]demo and see the consequence of not checking all the options.