ce/regime/controls.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
    SELECT
        COALESCE(abbreviated_caption, caption) AS title,
        COALESCE(url, path) AS link,
        parent_path, 0 AS level,
        namespace
    FROM sqlpage_aide_navigation
    WHERE namespace = 'prime' AND path='ce/regime/controls.sql'
    UNION ALL
    SELECT
        COALESCE(nav.abbreviated_caption, nav.caption) AS title,
        COALESCE(nav.url, nav.path) AS link,
        nav.parent_path, b.level + 1, nav.namespace
    FROM sqlpage_aide_navigation nav
    INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,      
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link        
FROM breadcrumbs ORDER BY level DESC;
              -- not including page title from sqlpage_aide_navigation
              

                SELECT 'title' AS component, (SELECT COALESCE(title, caption)
    FROM sqlpage_aide_navigation
   WHERE namespace = 'prime' AND path = 'ce/regime/controls.sql/index.sql') as contents;
    ;
  SELECT
  'text' AS component,
  ''|| $regimeType ||' Controls' AS title;
  SELECT
  description as contents FROM compliance_regime WHERE title = $regimeType::TEXT;
  SELECT
  'table' AS component,
  TRUE AS sort,
  TRUE AS search,
  "Control Code" AS markdown;
  SELECT '[' || control_code || ']('|| sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/ce/regime/control/control_detail.sql?id=' || control_code || '&regimeType='|| replace($regimeType,
" ", "%20")||')' AS "Control Code",
  scf_control AS "Title",
  scf_domain AS "Domain",
  control_description AS "Control Description",
  control_id AS "Requirements"
  FROM compliance_regime_control WHERE control_type=$regimeType::TEXT;