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!

Dynamic List -> Menu popup: showing URL rather than display values

mtJun 14 2024 — edited Jun 14 2024

using apex 23.2.1
I created a Shared Component → Dynamic List using the query shown below. I have it set with a static id, and Blank with Attributes, and Menu_PopUP - to use with a coordinating button.

when I click the button, I'm seeing the URLs rather than the display values….

What am I doing wrong?

And - is it better to use the syntax below to build the url, or APEX_PAGE.GET_URL, or APEX_UTIL.PREPARE_URL

thank you-

mt in ny

SELECT 
to_char(distribnmbr) AS display_value,
'f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.:::'||:P0_PARTNERSHIPID||','||:P0_DISTRIBID ||':'||to_char(PARTNERSHIPID)||',' ||to_char(DISTRIBID)  as r
FROM 
   distribution_v
WHERE 
NVL(productionid, -1)         = NVL(:P0_productionid,    NVL(productionid,  -1))
AND NVL(partnershipid, -1)    = NVL(:P0_partnershipid,   NVL(partnershipid, -1))

Added on Jun 14 2024

2 comments

221 views