qltyfolio/suite-data.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
    "name" as title from test_suites where CAST(id AS TEXT) = CAST($id AS TEXT);
    SELECT 'title'AS component,
      name as contents FROM test_suites  WHERE id = $id; 
     SELECT 'list'  AS component;
    SELECT
    '
 **Description**  :  ' || rn."description" AS description_md,
      '
 **Created By**  :  ' || rn.created_by AS description_md,
        '
 **Created At**  :  ' || rn.created_at AS description_md,
          '
 **Priority**  :  ' || rn.linked_requirements AS description_md,
            '
' || rn.body AS description_md
FROM test_suites rn WHERE id = $id;

SELECT 'title'  AS component,
      'Test Case Group' as contents;
    --SELECT
    -- 'A structured summary of a specific test scenario, detailing its purpose, preconditions, test data, steps, and expected results. The description ensures clarity on the tests objective, enabling accurate validation of functionality or compliance. It aligns with defined requirements, identifies edge cases, and facilitates efficient defect detection during execution.
    -- ' as empty_description;

SELECT 'table' as component,
      TRUE AS sort,
        --TRUE AS search,
          'URL' AS align_left,
            'title' AS align_left,
              'group' as markdown,
              'id' as markdown,
              'Test Cases' as markdown;
    SELECT
    '[' || group_id || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/group-detail.sql?id='|| group_id || ')' as id,
      group_name AS "title",
        '[' || test_case_count || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/test-cases.sql?id='|| group_id || ')' AS 'Test Cases',
      
      created_by as "Created By",
      formatted_test_case_created_at as "Created On"
    FROM test_cases_run_status
    WHERE suite_id = $id order by group_id asc;