SQLpage
SQLpage copied to clipboard
Column Component - items not working in mysql
Introduction
When attempting to use the new columns component, using Mysql database, the item are not being displayed.
Using the same example from documentation, only change is to use the JSON_OBJECT to generate json for item.
select
'columns' as component;
select
'Standard Plan' as title,
'$49' as value,
'star' as icon,
'A standard plan for small teams.' as description,
JSON_OBJECT("icon", "check", "color", "green", "description", "Collaboration Tools") as item,
JSON_OBJECT("icon", "check", "color", "green", "description", "Custom data sources") as item,
JSON_OBJECT("icon", "check", "color", "green", "description", "Priority support") as item,
'#' as link,
'Select' as button_text,
'success' as button_color,
'green' as value_color,
'/month' as small_text;