qltyfolio/group-detail.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 'title' AS component, (SELECT COALESCE(title, caption)
    FROM sqlpage_aide_navigation
   WHERE namespace = 'prime' AND path = 'qltyfolio/group-detail.sql/index.sql') as contents;
    ;

    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
    s."name" as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qltyfolio/suite-data.sql?id=' || s.id as link
         from groups g
        inner join  test_suites s on s.id = g.suite_id where g.id = $id;
    select
    g."name" as title from groups g
        inner join  test_suites s on s.id = g.suite_id where g.id = $id;
        

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

    SELECT 'list'AS component;
    SELECT
    ' **Id**  :  ' || rn.id AS description_md,
      '
 **name**  :  ' || rn."name" AS description_md,
        '
 **Description**  :  ' || rn."description" AS description_md,
          '
 **Created By**  :  ' || rn."created_by" AS description_md,
            '
 **Created On**  :  ' || strftime('%d-%m-%Y', rn."created_at") AS description_md,
              '
' || rn.body AS description_md
FROM groups rn
INNER JOIN test_suites st ON st.id = rn.suite_id
WHERE rn.id = $id;