| console/content/table/ur_ingest_session_udi_pgp_sql.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_udi_pgp_sql table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_udi_pgp_sql (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_udi_pgp_sql);
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 'text' AS component, '[ur_ingest_session_udi_pgp_sql (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_udi_pgp_sql&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_udi_pgp_sql
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 |
| console/content/table/orchestration_nature.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_nature table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_nature (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_nature);
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 'text' AS component, '[orchestration_nature (table) Schema](console/info-schema/table.sql?name=orchestration_nature&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_nature
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 |
| console/content/table/orchestration_session.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session);
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 'text' AS component, '[orchestration_session (table) Schema](console/info-schema/table.sql?name=orchestration_session&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session
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 |
| console/content/table/orchestration_session_entry.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_entry table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_entry (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_entry);
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 'text' AS component, '[orchestration_session_entry (table) Schema](console/info-schema/table.sql?name=orchestration_session_entry&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_entry
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 |
| console/content/table/orchestration_session_state.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_state table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_state (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_state);
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 'text' AS component, '[orchestration_session_state (table) Schema](console/info-schema/table.sql?name=orchestration_session_state&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_state
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 |
| console/content/table/orchestration_session_exec.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_exec table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_exec (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_exec);
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 'text' AS component, '[orchestration_session_exec (table) Schema](console/info-schema/table.sql?name=orchestration_session_exec&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_exec
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 |
| console/content/table/orchestration_session_issue.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_issue table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_issue (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_issue);
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 'text' AS component, '[orchestration_session_issue (table) Schema](console/info-schema/table.sql?name=orchestration_session_issue&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_issue
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 |
| console/content/table/orchestration_session_issue_relation.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_issue_relation table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_issue_relation (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_issue_relation);
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 'text' AS component, '[orchestration_session_issue_relation (table) Schema](console/info-schema/table.sql?name=orchestration_session_issue_relation&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_issue_relation
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 |
| console/content/table/orchestration_session_log.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_log table' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_log (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_log);
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 'text' AS component, '[orchestration_session_log (table) Schema](console/info-schema/table.sql?name=orchestration_session_log&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_log
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 |
| console/content/table/uniform_resource_graph.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_graph table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_graph (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_graph);
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 'text' AS component, '[uniform_resource_graph (table) Schema](console/info-schema/table.sql?name=uniform_resource_graph&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_graph
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 |
| console/content/table/uniform_resource_edge.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_edge table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_edge (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_edge);
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 'text' AS component, '[uniform_resource_edge (table) Schema](console/info-schema/table.sql?name=uniform_resource_edge&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_edge
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 |
| console/content/table/surveilr_osquery_ms_node.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_osquery_ms_node table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_osquery_ms_node (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_osquery_ms_node);
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 'text' AS component, '[surveilr_osquery_ms_node (table) Schema](console/info-schema/table.sql?name=surveilr_osquery_ms_node&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_osquery_ms_node
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 |
| console/content/table/ur_ingest_session_osquery_ms_log.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_osquery_ms_log table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_osquery_ms_log (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_osquery_ms_log);
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 'text' AS component, '[ur_ingest_session_osquery_ms_log (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_osquery_ms_log&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_osquery_ms_log
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 |
| console/content/table/osquery_policy.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'osquery_policy table' as title, '#' AS link;
SELECT 'title' AS component, 'osquery_policy (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM osquery_policy);
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 'text' AS component, '[osquery_policy (table) Schema](console/info-schema/table.sql?name=osquery_policy&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM osquery_policy
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 |
| console/content/table/surveilr_osquery_ms_distributed_query.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_osquery_ms_distributed_query table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_osquery_ms_distributed_query (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_osquery_ms_distributed_query);
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 'text' AS component, '[surveilr_osquery_ms_distributed_query (table) Schema](console/info-schema/table.sql?name=surveilr_osquery_ms_distributed_query&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_osquery_ms_distributed_query
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 |
| console/content/table/surveilr_osquery_ms_distributed_result.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_osquery_ms_distributed_result table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_osquery_ms_distributed_result (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_osquery_ms_distributed_result);
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 'text' AS component, '[surveilr_osquery_ms_distributed_result (table) Schema](console/info-schema/table.sql?name=surveilr_osquery_ms_distributed_result&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_osquery_ms_distributed_result
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 |
| console/content/table/surveilr_osquery_ms_carve.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_osquery_ms_carve table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_osquery_ms_carve (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_osquery_ms_carve);
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 'text' AS component, '[surveilr_osquery_ms_carve (table) Schema](console/info-schema/table.sql?name=surveilr_osquery_ms_carve&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_osquery_ms_carve
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 |
| console/content/view/code_notebook_cell_versions.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_cell_versions view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_cell_versions (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_cell_versions);
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 'text' AS component, '[code_notebook_cell_versions (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_versions&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_cell_versions
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 |
| console/content/view/code_notebook_cell_latest.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_cell_latest view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_cell_latest (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_cell_latest);
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 'text' AS component, '[code_notebook_cell_latest (view) Schema](console/info-schema/view.sql?name=code_notebook_cell_latest&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_cell_latest
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 |
| console/content/view/code_notebook_sql_cell_migratable_version.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_sql_cell_migratable_version view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_sql_cell_migratable_version (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_sql_cell_migratable_version);
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 'text' AS component, '[code_notebook_sql_cell_migratable_version (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_version&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_sql_cell_migratable_version
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 |
| console/content/view/code_notebook_sql_cell_migratable.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_sql_cell_migratable view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_sql_cell_migratable (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_sql_cell_migratable);
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 'text' AS component, '[code_notebook_sql_cell_migratable (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_sql_cell_migratable
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 |
| console/content/view/code_notebook_sql_cell_migratable_state.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_sql_cell_migratable_state view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_sql_cell_migratable_state (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_sql_cell_migratable_state);
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 'text' AS component, '[code_notebook_sql_cell_migratable_state (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_state&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_sql_cell_migratable_state
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 |
| console/content/view/code_notebook_sql_cell_migratable_not_executed.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_sql_cell_migratable_not_executed view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_sql_cell_migratable_not_executed (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_sql_cell_migratable_not_executed);
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 'text' AS component, '[code_notebook_sql_cell_migratable_not_executed (view) Schema](console/info-schema/view.sql?name=code_notebook_sql_cell_migratable_not_executed&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_sql_cell_migratable_not_executed
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 |
| console/content/view/code_notebook_migration_sql.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_migration_sql view' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_migration_sql (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_migration_sql);
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 'text' AS component, '[code_notebook_migration_sql (view) Schema](console/info-schema/view.sql?name=code_notebook_migration_sql&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_migration_sql
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 |
| console/content/view/orchestration_session_by_device.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_by_device view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_by_device (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_by_device);
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 'text' AS component, '[orchestration_session_by_device (view) Schema](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_by_device
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 |
| console/content/view/orchestration_session_duration.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_duration view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_duration (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_duration);
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 'text' AS component, '[orchestration_session_duration (view) Schema](console/info-schema/view.sql?name=orchestration_session_duration&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_duration
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 |
| console/content/view/orchestration_success_rate.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_success_rate view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_success_rate (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_success_rate);
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 'text' AS component, '[orchestration_success_rate (view) Schema](console/info-schema/view.sql?name=orchestration_success_rate&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_success_rate
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 |
| console/content/view/orchestration_session_script.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_script view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_script (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_script);
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 'text' AS component, '[orchestration_session_script (view) Schema](console/info-schema/view.sql?name=orchestration_session_script&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_script
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 |
| console/content/view/orchestration_executions_by_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_executions_by_type view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_executions_by_type (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_executions_by_type);
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 'text' AS component, '[orchestration_executions_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_executions_by_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_executions_by_type
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 |
| console/content/view/orchestration_execution_success_rate_by_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_execution_success_rate_by_type view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_execution_success_rate_by_type (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_execution_success_rate_by_type);
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 'text' AS component, '[orchestration_execution_success_rate_by_type (view) Schema](console/info-schema/view.sql?name=orchestration_execution_success_rate_by_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_execution_success_rate_by_type
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 |
| console/content/view/orchestration_session_summary.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_session_summary view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_session_summary (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_session_summary);
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 'text' AS component, '[orchestration_session_summary (view) Schema](console/info-schema/view.sql?name=orchestration_session_summary&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_session_summary
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 |
| console/content/view/orchestration_issue_remediation.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_issue_remediation view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_issue_remediation (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_issue_remediation);
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 'text' AS component, '[orchestration_issue_remediation (view) Schema](console/info-schema/view.sql?name=orchestration_issue_remediation&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_issue_remediation
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 |
| console/content/view/orchestration_logs_by_session.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'orchestration_logs_by_session view' as title, '#' AS link;
SELECT 'title' AS component, 'orchestration_logs_by_session (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM orchestration_logs_by_session);
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 'text' AS component, '[orchestration_logs_by_session (view) Schema](console/info-schema/view.sql?name=orchestration_logs_by_session&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM orchestration_logs_by_session
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 |
| console/content/view/plm_graph.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'plm_graph view' as title, '#' AS link;
SELECT 'title' AS component, 'plm_graph (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM plm_graph);
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 'text' AS component, '[plm_graph (view) Schema](console/info-schema/view.sql?name=plm_graph&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM plm_graph
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 |
| console/content/view/imap_graph.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'imap_graph view' as title, '#' AS link;
SELECT 'title' AS component, 'imap_graph (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM imap_graph);
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 'text' AS component, '[imap_graph (view) Schema](console/info-schema/view.sql?name=imap_graph&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM imap_graph
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 |
| console/content/view/filesystem_graph.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'filesystem_graph view' as title, '#' AS link;
SELECT 'title' AS component, 'filesystem_graph (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM filesystem_graph);
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 'text' AS component, '[filesystem_graph (view) Schema](console/info-schema/view.sql?name=filesystem_graph&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM filesystem_graph
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 |
| console/content/view/threat_model.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'threat_model view' as title, '#' AS link;
SELECT 'title' AS component, 'threat_model (view) Content' 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 'text' AS component, '[threat_model (view) Schema](console/info-schema/view.sql?name=threat_model&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * 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 |
| console/content/view/web_application.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'web_application view' as title, '#' AS link;
SELECT 'title' AS component, 'web_application (view) Content' as contents;
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 'text' AS component, '[web_application (view) Schema](console/info-schema/view.sql?name=web_application&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * 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 |
| console/content/view/managed_application.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'managed_application view' as title, '#' AS link;
SELECT 'title' AS component, 'managed_application (view) Content' 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 'text' AS component, '[managed_application (view) Schema](console/info-schema/view.sql?name=managed_application&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * 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 |
| console/content/view/sql_database.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'sql_database view' as title, '#' AS link;
SELECT 'title' AS component, 'sql_database (view) Content' as contents;
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 'text' AS component, '[sql_database (view) Schema](console/info-schema/view.sql?name=sql_database&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * 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 |
| console/content/view/boundaries.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'boundaries view' as title, '#' AS link;
SELECT 'title' AS component, 'boundaries (view) Content' as contents;
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 'text' AS component, '[boundaries (view) Schema](console/info-schema/view.sql?name=boundaries&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * 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 |
| console/content/view/uniform_resource_file.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_file view' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_file (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_file);
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 'text' AS component, '[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_file
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 |
| console/content/view/uniform_resource_imap.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_imap view' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_imap (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_imap);
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 'text' AS component, '[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_imap
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 |
| console/content/view/uniform_resource_imap_content.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_imap_content view' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_imap_content (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_imap_content);
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 'text' AS component, '[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_imap_content
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 |
| console/content/view/ur_ingest_session_files_stats.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_files_stats view' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_files_stats (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_files_stats);
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 'text' AS component, '[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_files_stats
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 |
| console/content/view/ur_ingest_session_files_stats_latest.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_files_stats_latest view' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_files_stats_latest (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_files_stats_latest);
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 'text' AS component, '[ur_ingest_session_files_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats_latest&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_files_stats_latest
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 |
| console/content/view/ur_ingest_session_tasks_stats.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_tasks_stats view' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_tasks_stats (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_tasks_stats);
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 'text' AS component, '[ur_ingest_session_tasks_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_tasks_stats
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 |
| console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_tasks_stats_latest view' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_tasks_stats_latest (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_tasks_stats_latest);
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 'text' AS component, '[ur_ingest_session_tasks_stats_latest (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_tasks_stats_latest&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_tasks_stats_latest
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 |
| console/content/view/ur_ingest_session_file_issue.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_file_issue view' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_file_issue (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_file_issue);
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 'text' AS component, '[ur_ingest_session_file_issue (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_file_issue&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_file_issue
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 |
| console/content/view/console_information_schema_table.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'console_information_schema_table view' as title, '#' AS link;
SELECT 'title' AS component, 'console_information_schema_table (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM console_information_schema_table);
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 'text' AS component, '[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM console_information_schema_table
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 |