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 "list" component
A vertical list of items. Each item can be clickable and link to another page.
Top-level parameters
title
Text header at the top of the list.
Row-level parameters
title
REQUIRED. Name of the list item, displayed prominently.
active
Whether this item in the list is considered "active". Active items are displayed more prominently.
color
The name of a color, to be displayed as a dot near the list item contents.
description
A description of the list item, displayed as greyed-out text.
icon
An icon name (from tabler-icons.io) to display on the left side of the item.
link
An URL to which the user should be taken when they click on the list item.
Example 1
The most basic list
SELECT
'list' as component;
SELECT
'A' as title;
SELECT
'B' as title;
SELECT
'C' as title;
Result
Example 2
A beautiful list with bells and whistles.
SELECT
'list' as component,
'Popular websites' as title;
SELECT
'Google' as title,
'https://google.com' as link,
'A search engine' as description,
'red' as color,
'brand-google' as icon,
1 as active;
SELECT
'Wikipedia' as title,
'https://wikipedia.org' as link,
'An encyclopedia' as description,
'blue' as color,
'world' as icon;