sqlpage_files (table) Content
| console/content/table/orchestration_session_issue_relation.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue_relation.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_issue_relation.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/orchestration_session_log.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_log.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/orchestration_session_log.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/uniform_resource_graph.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/uniform_resource_edge.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_edge.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/uniform_resource_edge.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/surveilr_osquery_ms_node.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_node.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/ur_ingest_session_osquery_ms_log.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/ur_ingest_session_osquery_ms_log.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/ur_ingest_session_osquery_ms_log.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/osquery_policy.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/osquery_policy.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/osquery_policy.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/surveilr_osquery_ms_distributed_query.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_query.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_query.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/surveilr_osquery_ms_distributed_result.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_result.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_distributed_result.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/table/surveilr_osquery_ms_carve.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_carve.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/table/surveilr_osquery_ms_carve.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_session_by_device.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_by_device.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_by_device.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_session_duration.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_duration.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_duration.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_success_rate.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_success_rate.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_success_rate.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_session_script.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_script.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_script.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_executions_by_type.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_executions_by_type.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_executions_by_type.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_execution_success_rate_by_type.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_execution_success_rate_by_type.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_execution_success_rate_by_type.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_session_summary.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_summary.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_session_summary.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_issue_remediation.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_issue_remediation.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_issue_remediation.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/orchestration_logs_by_session.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_logs_by_session.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/orchestration_logs_by_session.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/plm_graph.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/plm_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/plm_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/imap_graph.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/imap_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/imap_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/filesystem_graph.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/filesystem_graph.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/filesystem_graph.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/threat_model.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/threat_model.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/threat_model.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/web_application.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/web_application.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/web_application.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/managed_application.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/managed_application.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/managed_application.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/sql_database.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/sql_database.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/sql_database.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/boundaries.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/boundaries.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/boundaries.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/uniform_resource_file.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/uniform_resource_imap.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/uniform_resource_imap_content.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/ur_ingest_session_files_stats.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/ur_ingest_session_files_stats_latest.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/ur_ingest_session_tasks_stats.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/ur_ingest_session_tasks_stats_latest.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| console/content/view/ur_ingest_session_file_issue.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-15 09:28:45 |
| opsfolio/index.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/index.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation select 'card' as component, 3 as columns; SELECT caption as title, COALESCE(url, path) as link, description FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND parent_path = '/opsfolio' AND sibling_order = 2 ORDER BY sibling_order; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation SELECT 'card' AS component, 4 AS columns SELECT 'Threat Model Analysis Report' AS title, 'arrow-big-right' AS icon, '/opsfolio/info/assurance/threat_model/threat_model_analysis_report.sql' AS link SELECT 'Web Application' AS title, 'arrow-big-right' AS icon, '/opsfolio/info/assurance/threat_model/web_application.sql' AS link SELECT 'Managed Application' AS title, 'arrow-big-right' AS icon, '/opsfolio/info/assurance/threat_model/managed_application.sql' AS link SELECT 'SQL Database' AS title, 'arrow-big-right' AS icon, '/opsfolio/info/assurance/threat_model/sql_database.sql' AS link SELECT 'Boundaries' AS title, 'arrow-big-right' AS icon, '/opsfolio/info/assurance/threat_model/boundaries.sql' AS link; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/threat_model_analysis_report.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/threat_model_analysis_report.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- 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 = 'opsfolio/info/assurance/threat_model/threat_model_analysis_report.sql/index.sql') as contents; ; SET total_rows = (SELECT COUNT(*) FROM threat_model ); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'table' AS component, 'Title' as markdown SELECT '[' || title || '](/opsfolio/info/assurance/threat_model/threat_model_analysis_report/detail.sql?id=' || id || ')' AS "Title", category, interaction, priority, "state" FROM threat_model LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md ; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/web_application.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/web_application.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation SET total_rows = (SELECT COUNT(*) FROM web_application ); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'title' AS component, (SELECT COALESCE(title, caption) FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'opsfolio/info/assurance/threat_model/web_application.sql/index.sql') as contents; ; SELECT 'list' as component SELECT Title as title FROM web_application LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md ; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/managed_application.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/managed_application.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- 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 = 'opsfolio/info/assurance/threat_model/managed_application.sql/index.sql') as contents; ; SET total_rows = (SELECT COUNT(*) FROM managed_application ); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'list' as component SELECT Title as title FROM managed_application LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md ; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/sql_database.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/sql_database.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation SET total_rows = (SELECT COUNT(*) FROM sql_database ); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'title' AS component, (SELECT COALESCE(title, caption) FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'opsfolio/info/assurance/threat_model/sql_database.sql/index.sql') as contents; ; SELECT 'list' AS component SELECT Title as title FROM sql_database LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md ; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/boundaries.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/boundaries.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation SET total_rows = (SELECT COUNT(*) FROM boundaries ); SET limit = COALESCE($limit, 50); SET offset = COALESCE($offset, 0); SET total_pages = ($total_rows + $limit - 1) / $limit; SET current_page = ($offset / $limit) + 1; SELECT 'title' AS component, (SELECT COALESCE(title, caption) FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'opsfolio/info/assurance/threat_model/boundaries.sql/index.sql') as contents; ; SELECT 'list' AS component SELECT boundary as title FROM boundaries LIMIT $limit OFFSET $offset; SELECT 'text' AS component, (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' || '(Page ' || $current_page || ' of ' || $total_pages || ") " || (SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END) AS contents_md ; | 2025-04-15 09:28:45 |
| opsfolio/info/assurance/threat_model/threat_model_analysis_report/detail.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='opsfolio/info/assurance/threat_model/threat_model_analysis_report/detail.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- 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 = 'opsfolio/info/assurance/threat_model/threat_model_analysis_report/detail.sql/index.sql') as contents; ; -- Component definition SELECT 'card' AS component, 2 AS columns; -- Title section SELECT 'Title' AS title, title AS description FROM threat_model WHERE id = $id::TEXT; -- Category section SELECT 'Category' AS title, title AS description FROM threat_model WHERE id = $id::TEXT; -- Short description section SELECT 'card' AS component, 1 AS columns; SELECT 'Short Description' AS title, short_description AS description FROM threat_model WHERE id = $id::TEXT; -- Full description section SELECT 'Description' AS title, description AS description FROM threat_model WHERE id = $id::TEXT; -- Priority and State sections SELECT 'card' AS component, 2 AS columns; SELECT 'Priority' AS title, priority AS description FROM threat_model WHERE id = $id::TEXT; SELECT 'State' AS title, state AS description FROM threat_model WHERE id = $id::TEXT; | 2025-04-15 09:28:45 |
Previous (Page 5 of 5)