sqlpage_files (table) Content
| console/content/view/linkedin_company_follows.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/linkedin_company_follows.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/linkedin_company_follows.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/uniform_resource_file.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_file.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/uniform_resource_imap.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/uniform_resource_imap_content.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/uniform_resource_imap_content.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/ur_ingest_session_files_stats.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/ur_ingest_session_files_stats_latest.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_files_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/ur_ingest_session_tasks_stats.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/ur_ingest_session_tasks_stats_latest.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_tasks_stats_latest.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| console/content/view/ur_ingest_session_file_issue.sql | SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql' AS link WHERE $stats IS NULL; SELECT 'redirect' AS component,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content/view/ur_ingest_session_file_issue.auto.sql?stats=' || $stats AS link WHERE $stats IS NOT NULL; | 2025-04-17 22:11:10 |
| lie/index.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='lie/index.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation select 'text' as component, 'LinkedIn Explorer, will enable LinkedIn data integration into Surveilr. It includes manual data export, automated CSV ingestion, SQL Views for querying, and a Web UI for data analysis.' as contents; WITH navigation_cte AS ( SELECT COALESCE(title, caption) as title, description FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'lie'||'/index.sql' ) SELECT 'list' AS component, title, description FROM navigation_cte; SELECT caption as title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' || COALESCE(url, path) as link, description FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND parent_path = 'lie'||'/index.sql' ORDER BY sibling_order; | 2025-04-17 22:11:10 |
| lie/profile.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; SELECT 'breadcrumb' as component; WITH RECURSIVE breadcrumbs AS ( SELECT COALESCE(abbreviated_caption, caption) AS title, COALESCE(url, path) AS link, parent_path, 0 AS level, namespace FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path='lie/profile.sql' UNION ALL SELECT COALESCE(nav.abbreviated_caption, nav.caption) AS title, COALESCE(nav.url, nav.path) AS link, nav.parent_path, b.level + 1, nav.namespace FROM sqlpage_aide_navigation nav INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path ) SELECT title , sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link FROM breadcrumbs ORDER BY level DESC; -- not including page title from sqlpage_aide_navigation SELECT 'title' AS component, (SELECT COALESCE(title, caption) FROM sqlpage_aide_navigation WHERE namespace = 'prime' AND path = 'lie/profile.sql/index.sql') as contents; ; select 'text' as component, 'The Source List page provides a streamlined view of all collected content sources. This page displays only the origins of the content, such as sender information for email sources, making it easy to see where each piece of content came from. Use this list to quickly review and identify the various sources contributing to the curated content collection.' as contents; select 'datagrid' as component; select 'Name' as title, full_name as description FROM linkedin_profile; select 'Address' as title, address as description FROM linkedin_profile; select 'Birth Date' as title, birth_date as description FROM linkedin_profile; -- Dashboard count select 'card' as component, 3 as columns; SELECT 'Connection' as title, '## '||connection_count||' ##' as description_md, TRUE as active, 'home-link' as icon, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/connection.sql' as link FROM linkedin_connection_count; SELECT 'Skills' as title, '## '||total_skills||' ##' as description_md, TRUE as active, 'bulb' as icon, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/skills.sql' as link FROM linkedin_top_skills_count; SELECT 'Employment Timeline' as title, '## '||time_line_count||' ##' as description_md, TRUE as active, 'baseline-density-small' as icon, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/time_line.sql' as link FROM linkedin_employment_timeline_count; select 'card' as component, 2 as columns; select 'Learnings' as description_md, TRUE as active, 'book' as icon, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/learning.sql' as link; select 'Company Follows' as description_md, TRUE as active, 'building' as icon, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/company_follows.sql' as link; select 'title' as component, 'Education' as contents; SELECT 'table' AS component; SELECT * FROM linkedin_profile_education; | 2025-04-17 22:11:10 |
| lie/connection.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation --- Display breadcrumb SELECT 'breadcrumb' AS component; SELECT 'Home' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'LinkedIn Explorer' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link; SELECT 'Profile' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link; SELECT 'Connection' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/connection.sql' AS link; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) 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, 'The Source List page provides a streamlined view of all collected content sources. This page displays only the origins of the content, such as sender information for email sources, making it easy to see where each piece of content came from. Use this list to quickly review and identify the various sources contributing to the curated content collection.' as contents; -- Display uniform_resource table with pagination SELECT 'table' AS component, 'subject' AS markdown, 'Column Count' as align_right, TRUE as sort, TRUE as search; SELECT first_name, last_name, email 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 |
| lie/skills.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation --- Display breadcrumb SELECT 'breadcrumb' AS component; SELECT 'Home' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'AS link; SELECT 'LinkedIn Explorer' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link; SELECT 'Profile' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link; SELECT 'Skills' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/skills.sql' AS link; --- Dsply Page Title SELECT 'title' as component, 'Skills' as contents; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) 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, 'Ingest LinkedIn skills from CSV files into Resource Surveillance for seamless organization, querying, and analysis of skill data.' as contents; -- Display uniform_resource table with pagination SELECT 'table' AS component, 'subject' AS markdown, 'Column Count' as align_right, TRUE as sort, TRUE as search, 'from' AS markdown; SELECT skills 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 |
| lie/time_line.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation --- Display breadcrumb SELECT 'breadcrumb' AS component; SELECT 'Home' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'AS link; SELECT 'Linkedin Explorer' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link; SELECT 'Profile' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link; SELECT 'LinkedIn Employment Timeline' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/time_line.sql' AS link; --- Dsply Page Title SELECT 'title' as component, 'LinkedIn Employment Timeline' as contents; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) SET total_rows = (SELECT COUNT(*) FROM linkedin_employment_timeline ); 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, 'Ingest and organize employment data from LinkedIn positions to visualize career timelines and analyze professional history seamlessly.' as contents; -- Display uniform_resource table with pagination SELECT 'table' AS component, 'subject' AS markdown, 'Column Count' as align_right, TRUE as sort, TRUE as search, 'from' AS markdown; SELECT * FROM linkedin_employment_timeline 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 |
| lie/learning.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation --- Display breadcrumb SELECT 'breadcrumb' AS component; SELECT 'Home' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'AS link; SELECT 'Linkedin Explorer' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link; SELECT 'Profile' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link; SELECT 'Learning' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/learning.sql' AS link; --- Dsply Page Title SELECT 'title' as component, 'Learning' as contents; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) SET total_rows = (SELECT COUNT(*) FROM linkedin_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, 'Enhance your professional profile by seamlessly listing your learnings and courses directly from LinkedIn.' as contents; -- Display uniform_resource table with pagination SELECT 'table' AS component, 'subject' AS markdown, 'Column Count' as align_right, TRUE as sort, TRUE as search, 'from' AS markdown; SELECT * FROM linkedin_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 |
| lie/company_follows.sql | SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties; -- not including breadcrumbs from sqlpage_aide_navigation -- not including page title from sqlpage_aide_navigation --- Display breadcrumb SELECT 'breadcrumb' AS component; SELECT 'Home' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link; SELECT 'Linkedin Explorer' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/index.sql' AS link; SELECT 'Profile' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/profile.sql' AS link; SELECT 'Company Follows' AS title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/lie/company_follows.sql' AS link; --- Dsply Page Title SELECT 'title' as component, 'Company Follows' as contents; -- sets up $limit, $offset, and other variables (use pagination.debugVars() to see values in web-ui) SET total_rows = (SELECT COUNT(*) FROM linkedin_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, 'This feature allows users to view a curated list of companies they follow on LinkedIn. It provides insights into the user''s professional interests and industry preferences, showcasing the organizations they engage with and stay updated on. With a clear and interactive interface, this feature enhances the user''s profile by highlighting their network and areas of interest.' AS contents; -- Display uniform_resource table with pagination SELECT 'table' AS component, 'subject' AS markdown, 'Column Count' as align_right, TRUE as sort, TRUE as search, 'from' AS markdown; SELECT * FROM linkedin_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 |
Previous (Page 6 of 6)