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 "alert" component
A visually distinctive message or notification.
Top-level parameters
Row-level parameters
title
REQUIRED. Title of the alert message.
color
The color theme for the alert message.
description
Detailed description or content of the alert message.
dismissible
Whether the user can close the alert message.
icon
Icon name (from tabler-icons.io) to display next to the alert message.
important
Set this to TRUE to make the alert message more prominent.
link
A URL to link to from the alert message.
link_text
Customize the text of the link in the alert message. The default is "Ok".
Example 1
A basic alert message
SELECT
'alert' as component;
SELECT
'Attention' as title,
'This is an important message.' as description;
Result
Attention
Example 2
A list of notifications
SELECT
'alert' as component;
SELECT
'Success' as title,
'Item successfully added to your cart.' as description,
'check' as icon,
'green' as color;
SELECT
'Warning' as title,
'Your cart is almost full.' as description,
'alert-triangle' as icon,
'yellow' as color;
SELECT
'Error' as title,
'Your cart is full.' as description,
'alert-circle' as icon,
'red' as color;
Result
Success
Warning
Error
Example 3
A full-featured notification message with a link
SELECT
'alert' as component;
SELECT
'Your dashboard is ready!' as title,
'analyze' as icon,
'teal' as color,
1 as dismissible,
'Your public web dashboard was successfully created.' as description,
'/index.sql' as link;
Result
Example 4
An important danger alert message with an icon and color
SELECT
'alert' as component;
SELECT
'Alert' as title,
'alert-circle' as icon,
'red' as color,
1 as important,
1 as dismissible,
'SQLPage is entirely free and open source.' as description,
'https://github.com/lovasoa/SQLPage' as link,
'See source code' as link_text;