Skip to Main Content

Cards: Dynamic List

List SQL

  
with cards (title, icon, color) as (
  select 'Hot', 'fa-fire', 'u-hot' from dual union all
  select 'Warning', 'fa-exclamation-triangle-o', 'u-warning' from dual union all
  select 'Danger', 'fa-exclamation-diamond-o', 'u-danger' from dual union all
  select 'Info', 'fa-info-circle-o', 'u-info' from dual union all
  select 'Success', 'fa-check-circle-o', 'u-success' from dual union all
  select 'Custom', 'fa-wrench', 'u-color-6' from dual
)
select
   null     "level",
   title    label,
   '#'      target,
   'NO'     is_current,
   icon     image,
   null     image_attribute,
   null     image_alt_attribute,
   null     a01, -- Description
   null     a02, -- Secondary Information
   null     a03, -- Initials
   null     a04, -- List Item CSS Classes
   null     a05, -- Link Attributes
   color    a06, -- Card Color Class
   null     a07  -- Subtitle
from
   cards