Home/ Questions/Q 1137
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-09-23T22:13:34+00:00

Friendly URL- Interactive Filter URL report

  • 0
  • 0

Hi Vinish,

I am using 20.1 apex and in dashboard i am showing the list of items that got created today.

i have a timestamp column in the item table where i can query the items that are created in particular day.

Now i am unable to pass this as a parameter to the interactive report page in URL.

Could you please help on this request

 

Thanks,

Devanand

apexfriendly url
Share
Leave an answer

Leave an answer

Browse

6 Answers

  1. If you are passing that Timestamp column to a page using the link target property, then you should escape the special characters (:/) using the backslashes. Below is an example:

    Escape special characters for link in Oracle Apex.

    And even if you are using the friendly URLs, you can still use the old URL format to open the page. For example, if you are creating a link in your SQL query, use the following example:

    select ITEM_ID,
CDATE,
'f?p=&APP_ID.:35:&APP_SESSION.:::35:P35_TS:'||'\'||TO_CHAR(TSDATE, 'DD/MM/YYYY HH24:MI:SS')||'\' LINK
from ITEM

    In the above SQL query also, I am using backslashes to escape special characters a timestamp field having.

    Please let me know if I got your issue right.

    Or explain it in more detail if you have some other issues.

  2. Hi Vinish, Thanks for your inputs. it solved my problem. Regards Devanand