Discussions
Categories
- 385.5K All Categories
- 4.9K Data
- 2.5K Big Data Appliance
- 2.4K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Refresh line chart and legend to initial view

Hi,
i've got a line chart that is filled by user choices in selection lists. The three selection lists (hierarchy exists - 1st list choice determines what choices can be made in 2nd list and so on) are getting filled by different select statements, each one has a seperate table as source (assignments are determined via IDs). My line chart is refreshed whenever a choice is made in the selection lists via dynamic action (Event: change). So far, so good - everything works fine till this point.
When the chart is refreshed, I would like to get the initial view, just as a user made a choice in the selection lists. The legend does not get refreshed and keeps the setting for "hide/show" once modified before and the view in the chart stays at the same zoom level as before.
Is there a way to refresh the chart and legend and come up with the initial view?
I would really appreciate any help!
Cheers,
Phil
Best Answer
-
Didn't come up with a real solution, but took another route with a workaround: I'm generating the link via javascript location.assign( ) method dynamically and fill in the user's choices in the selection lists. This way, the page is reloaded everything works fine.
Answers
-
I was able to find what is causing my problem: The different objects I have in my database-table rows which are queried to fill my chart have timestamps. These timestamps are the values on the x axis (so to speak my time line). The process of recording the values for the objects started and in some cases ended at different points in time. When I zoom in the chart at, let's say, 1st of March 2020 and then refresh the chart by choosing a different object in the selection lists, for which the data recording started later (e.g. 1st of December 2020), I don't see any data in my zoomed-in view. Furthermore, the overview seems so behave a little buggy: When navigating via the overview, it is not corresponding to the main view anymore.
This is why I'd like to try to refresh to a max zoomed-out view when refreshing my chart - or rather show the data for all the records over the different periods of time for the objects without loading them and still being stuck at a point of time from the previous shown object that doesn't exist in the data of the currently chosen object.
In addition, I would appreciate any other idea to solve this problem as well, of course! ;-)
-
Didn't come up with a real solution, but took another route with a workaround: I'm generating the link via javascript location.assign( ) method dynamically and fill in the user's choices in the selection lists. This way, the page is reloaded everything works fine.