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 
;