Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
Datasource
  • Default Datasource
  • Custom Datasource
If the default datasource is selected, the custom JDBC settings below will be ignored.
Userview Key Name

When defined, additional condition will be appended using the value defined here as the parameter and the userview key value as the value.

Info
titleExample

SQL: SELECT category, count(category) FROM table1

Userview Key Name: type

Userview Key Value: val

Resultant SQL:  SELECT category, count(category) FROM table1 WHERE type = 'val'

When userview key value is defined, you may define #userviewKey# in your SQL query to have it replaced with the userview key value.

Info
titleExample

SQL: SELECT category, count(category) FROM table1 WHERE type = '#userviewKey#'

Userview Key Value: val

Resultant SQL:  SELECT category, count(category) FROM table1 WHERE type = 'val'

Interactive Chart

The following code can be modified and put in "Custom Footer" for interactive Chart.

Code Block
<script>
$(document).ready(function(){
    $('#jq_plot_chart').bind('jqplotDataClick',
        function (event, seriesIndex, pointIndex, data) {                
            console.log(event);
            console.log(seriesIndex);
            console.log(pointIndex);
            console.log(data);
        }
    );
});
</script>
Note

 This code does not work with OHLC and candlestick chart.