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!

Sending spaces with apex_page.get_url in cards vs standard report

Scott WesleyJun 5 2019 — edited Jun 5 2019

I have a problem sending a space in the value of a parameter in a generated link, but only for classic report standard columns.

If I use the following query using the cards template

select

'card title' as card_title

,'card text' as card_text

,'card subtext' as card_subtext

,apex_page.get_url(:APP_ID,2, p_items => 'P2_NEW', p_values => 'Hello world') as card_link

,'extra classes' card_modifiers

,'t-Button--warning' as card_icon

,null card_initials

from dual e

The space in the P2_NEW value appears as expected.

pastedImage_19.png

While embedding this the URL in the card

https://apex.oracle.com/pls/apex/f?p=29254:2:13849694523730::NO::P2_NEW:Hello%20world

If I define this as a standard report, and change the column to type Link, using #CARD_LINK# as the URL target, I get this URL constructed

https://apex.oracle.com/pls/apex/f?p=29254:2:13849694523730::NO::P2_NEW:Hello%2520universe

And the following value in the field:

Hello%20universe

pastedImage_24.png

How should I modify encoding? Escaping special characters attribute has no effect.

Behaviour seen in 18.2 and 191.

Cheers,

Scott.

This post has been answered by fac586 on Jun 5 2019
Jump to Answer
Comments
Post Details
Added on Jun 5 2019
3 comments
1,640 views