qualityfolio/bug-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 = 'qualityfolio/bug-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') || '/qualityfolio/index.sql' as link; 
    select 'bug list' as title,
      sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/qualityfolio/bug-list.sql' as link;  
      
    SELECT title FROM bug_report where id = $id order by created_at desc ;       
         

         

    /*SELECT 'title'AS component,
      title as contents FROM jira_issues where id = $id order by created_at desc;*/

    select 
    'datagrid'      as component,
    title         as title,
    'bulb'          as icon,
     '
 

**id**  :  ' || bug_id AS description_md,    
    '
 **Created By**  :  ' || reporter AS description_md,
    '
 **Run Date**  :  ' || strftime('%d-%m-%Y', created) AS description_md,
    '
 **Type**  :  ' || type AS description_md,
    '
 **Assigned**  :  ' || assignee AS description_md,
    '
 **Status**  :  ' || status AS description_md,
    '
' || description AS description_md 
      FROM  jira_issues  WHERE bug_id = $id;
     
     select 
    'datagrid'      as component,
    title         as title,
    'bulb'          as icon,
    '
 

 **id**  :  ' || b.id AS description_md,
    '
 **Title**  :  ' || b.title AS description_md,
    '
 **Created By**  :  ' || b.created_by AS description_md,
    '
 **Run Date**  :  ' || strftime('%d-%m-%Y', b.created_at) AS description_md,
    '
 **Type**  :  ' || b.type AS description_md,
    '
 **Priority**  :  ' || b.priority AS description_md,
    '
 **Assigned**  :  ' || b.assigned AS description_md,
    '
 **Status**  :  ' || b.status AS description_md,
    '
' || b.body AS description_md
    FROM  bug_report b 
    WHERE b.id = $id;