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

  • table / dbwqltable Will display the result as a table. This is the default type.
  • code Will display the result as a code block.
  • command Will display an OK dialog if the statement succeeds.
  • graphical Will display various charts (see below for details).
  • text Will display the result as text.
  • xml Will attempt to format and display the result as xml.

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>

← Formatting table results / Stacked area chart →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment