qltyfolio/test-plan.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='qltyfolio/test-plan.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
'breadcrumb' as component;
select
'Home' as title,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' as link;
select
'Test Management System' as title,
  sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/index.sql' as link;
select
'Test Plans' as title;



SELECT 'title'AS component, 
 'Test Plans' as contents; 
    SELECT 'text' as component,
    'A test plan is a high-level document that outlines the overall approach to testing a software application. It serves as a blueprint for the testing process.' as contents;

 SELECT 'table' as component,
    'Column Count' as align_right,
    TRUE as sort,
    TRUE as search,
    'id' as markdown,
    'test case count' as markdown;
  SELECT 
  '['||id||']('||sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/plan-overview.sql'||'?id='||id||')' as id,      
  name,
  '['||test_case_count||']('||sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/test-cases-list.sql'||'?id='||id||')' as "test case count",   
  created_by as "Created By",
  created_at as "Created On"
  FROM test_plan_list  order by id asc;