Search code examples
oracle-apex-5

Chart data does not link to interactive report page in APEX

I am attempting to create a link in an APEX (Oracle) chart which will open an interactive report page by using the "Link Builder -Target" wizard.

Link Builder -Target Dialog]1

Unfortunately the link is passing the column name (bob) rather than it's value:

https://xxxxxxxxx.xxxx.xxx:xxxx/ords/f?p=100:51:19910173095277::NO:RP,51:P51_TARGET_FIELD:#BOB#

If I substitute a value for #BOB#, the interactive page opens properly.

How do I get APEX to pass the column value rather than the column name to the linked page?

Solution

  • Page Designer vs Legacy Component View

    Apex 5.0 still using anychart charts, but using Page Designer the query of the chart is not validate. If you change to Legacy Component View you must see a error on save the chart with this query.

    The selects in anychart charts need a query following these terms:

    enter image description here

    *BOB column is not valid to use on Link Builder Target

    Try to put the value of the BOB column in the LINK column, like:

    SELECT bob AS LINK,

    or use APEX_UTIL.PREPARE_URL, in this case it's not necessary to use Link Builder Target. ...

    The query needs only three columns called LINK, LABEL and VALUE. Use alias to make this.

    SELECT 
APEX_UTIL.PREPARE_URL
('f?p=&APP_ID.:14:&APP_SESSION.::::P14_RECIEVER,P14_VALUE:' || bob || ',' || quantity) AS LINK, 
month AS LABEL, 
quantity AS VALUE
FROM mytable

    https://apex.oracle.com/pls/apex/f?p=4550

    Workspace: STACKQUESTIONS

    User: test

    Password: test

    Issue page: https://apex.oracle.com/pls/apex/f?p=145797:10