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.
The "alert" component
A visually distinctive message or notification.
REQUIRED. Title of the alert message.
The color theme for the alert message.
Detailed description or content of the alert message.
Whether the user can close the alert message.
Icon name (from tabler-icons.io) to display next to the alert message.
Set this to TRUE to make the alert message more prominent.
A URL to link to from the alert message.
Customize the text of the link in the alert message. The default is "Ok".
A basic alert message
SELECT 'alert' as component; SELECT 'Attention' as title, 'This is an important message.' as description;
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;
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;
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;