qltyfolio/plan-overview.sql

              SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
              -- not including breadcrumbs from sqlpage_aide_navigation
              -- 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
    'Plan List' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/test-plan.sql' as link;

    select
    "name" as title from test_plan where id = $id;
              

          SELECT 'title'AS component,
      name as contents FROM groups where id = $id; 

          SELECT 'list'AS component;
    SELECT
    ' **Id**  :  ' || id AS description_md,
      '
 **name**  :  ' || "name" AS description_md,
        '
 **Description**  :  ' || "description" AS description_md,
          '
 **Created By**  :  ' || "created_by" AS description_md,
            '
 **Created On**  :  ' || strftime('%d-%m-%Y', "created_at") AS description_md,
              '
' || body AS description_md
      FROM test_plan 
      WHERE id = $id;