tem/session/finding.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 = 'tem/session/finding.sql/index.sql') as contents;
  ;
--- Display breadcrumb
SELECT
    'breadcrumb' AS component;
SELECT
    'Home' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'    AS link;
SELECT
    'Threat Exposure Management' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/index.sql' AS link;  
SELECT 'Attack Surface Mapping By Session' AS title,
    sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/tem/attack_surface_mapping_session.sql' AS link;
SELECT tenant_name AS title,
    'tenant/attack_surface_mapping_inner.sql?tenant_id='|| $tenant_id AS link FROM tem_tenant WHERE tenant_id=$tenant_id;
SELECT 'Findings' AS title,
    '#' AS link;

--- Dsply Page Title
SELECT
  'title'   as component,
  'Findings' as contents;

SELECT
  'text'              as component,
  'Detailed insights from each security tool, including scan results, fingerprints, DNS records, TLS details, subdomain enumeration, and vulnerability assessments, mapped per asset for better threat exposure analysis.' as contents;


SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
'Asset' as markdown;

SELECT
    '[' || tool_name || '](' || sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '' || redirect_url || ')' AS 'Asset',
    session_name AS "Session Name", -- or tenant_name for tenant page
    count
FROM tem_session_finding_link
WHERE ur_ingest_session_id = $session_id;