Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to use LINK column in JET chart drill-down

JustJeffDec 20 2017 — edited Jan 8 2018

Howdy.

We're upgrading from Apex 5.0.4 to 5.1.3 and I'd like to update some of the graphs in an application to the spiffy new JET charts.  But I'm running into a problem.  The existing graphs (bar charts) use the LINK column in the sql to control linking.   In the Flash Chart Series attributes, the Link Type is set to 'Use Value of LINK Column'.  But in my new JET chart, that's not a option.  The Link Type attribute just has the three basic 'Redirect' options...no 'Use Value of LINK Column'.  I'm sure the answer is obvious, but durned if I can find it.  How can I use the value of my LINK column in a JET chart?

Thanks!
This post has been answered by Oleh Tyshchenko on Dec 21 2017
Jump to Answer

Comments

Oleh Tyshchenko
Answer

How about Link Type = "Redirect to URL", Link Target Type = "URL" and Link Target URL = "&MY_LINK_COLUMN_NAME_HERE."

Marked as Answer by JustJeff · Sep 27 2020
JustJeff

Thanks Oleh...that did the trick!  You win the gold star!   Well, actually it's green.  But it's still a star!

Scott Wesley

@"JustJeff" I was wondering if this really was your solution, because I find the syntax for link targets a little more tolerant than before.

However, in 5.1.3 I seem to need to double click, instead of single click in 5.1.4?

JustJeff

Hi Scott.

Yup, that really worked.  In my sql I created a URL with the name of LINK_URL, then in the 'Link Builder - Target' section of Apex I selected URL for the Type and entered &LINK_URL. for the URL.  It works fine.  But as you mentioned, you have to double-click to invoke the link with the spiffy new JET charts.  A single click ain't gonna get you nothing.  But I guess that's a small price to pay to get all the fancy new JET features.  I love they way they can expand and contract the graph!

Scott Wesley

Oh, I trust the substitution worked, I was just a little shocked that you had a conversion problem in the first place. I thought perhaps the double click thing confused the issue.

You may be interested in the work-around Hilary provided in the post I linked.

I suspect our users are going to love the ability to toggle the series by clicking the legend.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 5 2018
Added on Dec 20 2017
#apex-discussions
5 comments
1,161 views