Skip to Main Content

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.

Comments
Post Details
Added on Jun 5 2019
3 comments
1,070 views