| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| console/content/table/uniform_resource_learning.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_learning table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_learning (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_learning);
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_learning (table) Schema](console/info-schema/table.sql?name=uniform_resource_learning&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_learning
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-17 22:11:10 |
| console/content/table/uniform_resource_education.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_education table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_education (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_education);
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_education (table) Schema](console/info-schema/table.sql?name=uniform_resource_education&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_education
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-17 22:11:10 |
| console/content/table/uniform_resource_company_follows.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_company_follows table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_company_follows (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_company_follows);
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_company_follows (table) Schema](console/info-schema/table.sql?name=uniform_resource_company_follows&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_company_follows
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-17 22:11:10 |
| console/content/table/uniform_resource_profile.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_profile table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_profile (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_profile);
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_profile (table) Schema](console/info-schema/table.sql?name=uniform_resource_profile&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_profile
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-17 22:11:10 |
| console/content/table/uniform_resource_connections.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_connections table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_connections (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_connections);
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_connections (table) Schema](console/info-schema/table.sql?name=uniform_resource_connections&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_connections
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-17 22:11:10 |
| console/content/table/uniform_resource_positions.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_positions table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_positions (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_positions);
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_positions (table) Schema](console/info-schema/table.sql?name=uniform_resource_positions&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_positions
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-17 22:11:10 |
| console/content/table/uniform_resource_skills.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_skills table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_skills (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_skills);
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_skills (table) Schema](console/info-schema/table.sql?name=uniform_resource_skills&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_skills
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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| 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-17 22:11:10 |
| console/content/view/linkedin_profile.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 'linkedin_profile view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_profile (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_profile);
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, '[linkedin_profile (view) Schema](console/info-schema/view.sql?name=linkedin_profile&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 linkedin_profile
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-17 22:11:10 |
| console/content/view/linkedin_profile_education.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 'linkedin_profile_education view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_profile_education (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_profile_education);
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, '[linkedin_profile_education (view) Schema](console/info-schema/view.sql?name=linkedin_profile_education&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 linkedin_profile_education
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-17 22:11:10 |
| console/content/view/linkedin_connection_overview.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 'linkedin_connection_overview view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_connection_overview (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_connection_overview);
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, '[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&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 linkedin_connection_overview
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-17 22:11:10 |
| console/content/view/linkedin_connection_count.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 'linkedin_connection_count view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_connection_count (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_connection_count);
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, '[linkedin_connection_count (view) Schema](console/info-schema/view.sql?name=linkedin_connection_count&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 linkedin_connection_count
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-17 22:11:10 |
| console/content/view/linkedin_top_skills.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 'linkedin_top_skills view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_top_skills (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_top_skills);
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, '[linkedin_top_skills (view) Schema](console/info-schema/view.sql?name=linkedin_top_skills&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 linkedin_top_skills
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-17 22:11:10 |
| console/content/view/linkedin_top_skills_count.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 'linkedin_top_skills_count view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_top_skills_count (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_top_skills_count);
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, '[linkedin_top_skills_count (view) Schema](console/info-schema/view.sql?name=linkedin_top_skills_count&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 linkedin_top_skills_count
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-17 22:11:10 |
| console/content/view/linkedin_employment_timeline_count.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 'linkedin_employment_timeline_count view' as title, '#' AS link;
SELECT 'title' AS component, 'linkedin_employment_timeline_count (view) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM linkedin_employment_timeline_count);
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, '[linkedin_employment_timeline_count (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline_count&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 linkedin_employment_timeline_count
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-17 22:11:10 |