Databases Reference
In-Depth Information
View type is Dashboard and we defined how these views look, AnyChart will render multiple charts into
one.
There are many more options in AnyChart; for example, using specific events to refresh one
particular view of the dashboard (setViewData in JavaScript) or letting the chart behave completely
differently when the user is hovering over and clicking the chart.
The possibilities are endless and we can't show every possible feature of AnyChart, but by
understanding how AnyChart works behind the scenes and by looking at the different techniques used
throughout this chapter, you should be able to build your dream chart.
Most Common Issues
This section explains some issues people frequently seem to have and how they can be solved.
Search for a Specific Feature
Looking at the Oracle APEX Forum, most of the requests there are about how to do a certain thing in a
chart. In some cases, people don't know where to add a link or what every option in the APEX wizard
means. In other cases it wasn't supported by an option in the APEX screens and a change had to be
made in the XML, by using Custom XML and/or some JavaScript to generate the correct XML data. And
in still other cases, people wanted to produce a chart that was not licensed by Oracle, so they had to get a
valid license of AnyChart for APEX on the AnyChart website.
All the above questions have been answered in this chapter and you now have a good
understanding of how charts work in APEX and how you can enhance them. It's a matter of reading the
AnyChart documentation and finding the correct XML syntax and/or JavaScript to produce the chart you
want.
Invalid #HOST# with Reverse Proxy or HTTPS
Sometimes people say they don't see the chart. In that case it might be that they have issues with the
#HOST#
substitution string that APEX is using in the region definition of the chart:
"#IMAGE_PREFIX#flashchart/anychart_5/swf/#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=
&APP_ID.:&FLOW_PAGE_ID.:&APP_SESSION.:FLOW_FLASH_CHART5_R#REGION_ID#"
APEX might replace the
#HOST#
substitution string incorrectly. Many people running a reverse proxy
or running in https seem to initially have this problem. To solve this issue, you have a few options:
•
Hard-code the correct value for your environment or use a substitution string or
application item to pass the correct host value.
•
Pass through the host and port to your
mod_plsql
environment. For example:
PlsqlCGIEnvironmentList HTTP_HOST=<public hostname>:<public_port>
•
Use Virtual Hosts. For example:
<VirtualHost *:80>
# normal
ServerName myserver.com
ServerAlias myserver.com
DocumentRoot /home/myserver
Port 7777
…
