Result types


You can specift the result type with a “result-type” tag inside the result.

<result>
   <sql>select ... </sql>
   <result-type>table</result-type>
</result>

The currently available result types are

The graphical type

When specifying the graphical type there must also be a graphical tag inside the result.

<result>
   <sql>select ... </sql>
   <result-type>graphical</result-type>
   <graphical>
      ...
   </graphical>
</result>

This graphical tag then again contains the various chart specifications.

The currently supported charts are:

Tags that are common to all charts are:

title

The title.

<graphical>
   <title>Some title</title>
   ...
</graphical>

legend

Specifies details about the legend.
Contains an optional “side” specification, that specifies where the legend should be placed. Legal values are BOTTOM (default), LEFT, RIGHT, TOP
Contains an options “cols” specification that forces the number of columns in the legend.

<graphical>
   <legend>
      <side>RIGHT</side>
      <cols>2</cols>
   </legend>
   ...
</graphical>

top

Specifices an ordering and maximun number of rows for the resultset.

<graphical>
   <top>
      <column>A column name</column>
      <maxrows>20</maxrows>
      <order>asc</order>
   </top>
   ...
</graphical>

css

Can specify css for the chart.

For details of valid css referer to the JavaFX documentation, f.ex: JavaFX css tutorial

<graphical>
	<css>
		.default-color0.chart-area-symbol { -fx-background-color: #3e69a6, #233c5f; }
		.default-color1.chart-area-symbol { -fx-background-color: #66c859, #296321; }
		.default-color2.chart-area-symbol { -fx-background-color: #e6e6e6, #3f3f3f; }
		.default-color0.chart-series-area-line { -fx-stroke: #233c5f; }
		.default-color1.chart-series-area-line { -fx-stroke: #296321; }
		.default-color2.chart-series-area-line { -fx-stroke: #3f3f3f; }
		.default-color0.chart-series-area-fill { -fx-fill: #3e69a6; }
		.default-color1.chart-series-area-fill { -fx-fill: #66c859; }
		.default-color2.chart-series-area-fill { -fx-fill: #e6e6e6; }
	</css>
	...
</graphical>