SQLPage documentation
The two most important concepts in SQLPage are components and parameters.This page documents all the components that you can use in SQLPage and their parameters. Use this as a reference when building your SQL application.
components
The "chart" component
A component that plots data. Line, area, bar, and pie charts are all supported. Each item in the component is a data point in the graph.
Parameters
type (top-level)
REQUIRED. The type of chart: "line", "area", "bar", "column", or "pie".
labels (top-level)
Whether to show the data labels on the chart or not.
logarithmic (top-level)
Display the y-axis in logarithmic scale..
stacked (top-level)
Whether to cumulate values from different series.
time (top-level)
Whether the x-axis represents time. If set to true, the values will be formatted as dates for the user.
title (top-level)
The name of the chart.
ymax (top-level)
The maximum value for the y-axis.
ymin (top-level)
The minimal value for the y-axis.
x
REQUIRED. The value of the point on the horizontal axis
y
REQUIRED. The value of the point on the vertical axis
label
An alias for parameter "x"
series
If multiple series are represented and share the same y-axis, this parameter can be used to distinguish between them.
value
An alias for parameter "y"
Example 1
A pie chart.
SELECT
'chart' as component,
'Answers' as title,
'pie' as type,
'1' as labels;
SELECT
'Yes' as label,
'65' as value;
SELECT
'No' as label,
'35' as value;
Result
Answers
Example 2
An area chart
SELECT
'chart' as component,
'Syracuse' as title,
'area' as type;
SELECT
'0' as x,
'15' as y;
SELECT
'1' as x,
'46' as y;
SELECT
'2' as x,
'23' as y;
SELECT
'3' as x,
'70' as y;
SELECT
'4' as x,
'35' as y;
SELECT
'5' as x,
'106' as y;
Result
Syracuse
Example 3
A bar chart with multiple series.
SELECT
'chart' as component,
'Expenses' as title,
'bar' as type,
'1' as stacked;
SELECT
'Marketing' as series,
'2021' as x,
'35' as value;
SELECT
'Marketing' as series,
'2022' as x,
'15' as value;
SELECT
'Human resources' as series,
'2021' as x,
'30' as value;
SELECT
'Human resources' as series,
'2022' as x,
'55' as value;