{"queries":[{"id":"work_items_status_2024_by_requirement","compiledQueryString":"select *\nfrom eind.requirements_status\norder by delivery_outstanding desc","inputQueryString":"select *\nfrom eind.requirements_status\norder by delivery_outstanding desc","compiled":false,"inline":true},{"id":"work_items_status_2024","compiledQueryString":"select * from eind.pr_requirements_wkitm_status","inputQueryString":"select * from eind.pr_requirements_wkitm_status","compiled":false,"inline":true},{"id":"heatmap_data","compiledQueryString":"select * from eind.pr_requirment_work_item2","inputQueryString":"select * from eind.pr_requirment_work_item2","compiled":false,"inline":true},{"id":"heatmap_data_pr_filtered","compiledQueryString":"SELECT DISTINCT ON (pr_id,technical_description, merged_at)\n pr_id,\n technical_description,\n \n from (select * from eind.pr_requirment_work_item2)\n where pr_id = ${inputs.prid}\n ORDER BY\n pr_id,\n technical_description,\n merged_at DESC;","inputQueryString":"SELECT DISTINCT ON (pr_id,technical_description, merged_at)\n pr_id,\n technical_description,\n \n from ${heatmap_data}\n where pr_id = ${inputs.prid}\n ORDER BY\n pr_id,\n technical_description,\n merged_at DESC;","compiled":true,"inline":true},{"id":"heatmap_data_filtered_details","compiledQueryString":"SELECT DISTINCT ON (pr_id,requirement_id, work_item_id)\n pr_id,\n requirement_id,\n req_desc,\n work_item_id,\n work_item_description,\n milestone_id,\n milestone_description,\n merged_at,\n milestone_date\n from (select * from eind.pr_requirment_work_item2)\n where pr_id = ${inputs.prid}\n ORDER BY\n pr_id,\n requirement_id,\n work_item_id,\n merged_at DESC;","inputQueryString":"SELECT DISTINCT ON (pr_id,requirement_id, work_item_id)\n pr_id,\n requirement_id,\n req_desc,\n work_item_id,\n work_item_description,\n milestone_id,\n milestone_description,\n merged_at,\n milestone_date\n from ${heatmap_data}\n where pr_id = ${inputs.prid}\n ORDER BY\n pr_id,\n requirement_id,\n work_item_id,\n merged_at DESC;","compiled":true,"inline":true},{"id":"milestone_dates","compiledQueryString":"select distinct milestone_id,\n milestone_date,\n EXTRACT(MONTH FROM milestone_date) as mlst_month\n from eind.pr_requirment_work_item2\n order by milestone_date ASC","inputQueryString":"select distinct milestone_id,\n milestone_date,\n EXTRACT(MONTH FROM milestone_date) as mlst_month\n from eind.pr_requirment_work_item2\n order by milestone_date ASC","compiled":false,"inline":true},{"id":"roadmap_heatmap_data","compiledQueryString":"SELECT DISTINCT ON (pr_id, requirement_id, work_item_id, milestone_id)\n pr_id AS yval,\n ${inputs.x_axis_requirment.value} AS xval,\n COUNT(${inputs.x_axis_requirment.value}) AS count\nFROM (select * from eind.pr_requirment_work_item2)\nWHERE EXTRACT(MONTH FROM merged_at) = ${inputs.merged_month.value}\nGROUP BY\n pr_id,\n requirement_id,\n work_item_id,\n milestone_id,\n ${inputs.x_axis_requirment.value}\nORDER BY\n pr_id,\n requirement_id,\n work_item_id,\n milestone_id,\n count DESC\nLIMIT 2000;","inputQueryString":"SELECT DISTINCT ON (pr_id, requirement_id, work_item_id, milestone_id)\n pr_id AS yval,\n ${inputs.x_axis_requirment.value} AS xval,\n COUNT(${inputs.x_axis_requirment.value}) AS count\nFROM ${heatmap_data}\nWHERE EXTRACT(MONTH FROM merged_at) = ${inputs.merged_month.value}\nGROUP BY\n pr_id,\n requirement_id,\n work_item_id,\n milestone_id,\n ${inputs.x_axis_requirment.value}\nORDER BY\n pr_id,\n requirement_id,\n work_item_id,\n milestone_id,\n count DESC\nLIMIT 2000;","compiled":true,"inline":true},{"id":"roadmap_heatmap_data_total","compiledQueryString":"SELECT\n COUNT(DISTINCT pr_id) AS total_prs\nFROM (select * from eind.pr_requirment_work_item2)\nWHERE EXTRACT(MONTH FROM merged_at) = ${inputs.merged_month.value}\n\nlimit 2000;","inputQueryString":"SELECT\n COUNT(DISTINCT pr_id) AS total_prs\nFROM ${heatmap_data}\nWHERE EXTRACT(MONTH FROM merged_at) = ${inputs.merged_month.value}\n\nlimit 2000;","compiled":true,"inline":true},{"id":"roadmap_dimensions","compiledQueryString":"select \n pr_id,\n workstream_name,\n business_objective,\n category as \"Dev Activity\"\n \n from (select *\n from eind.dimemsion_data_2024)\n WHERE merged_at BETWEEN DATE '2024-01-01' AND DATE '2024-12-31'","inputQueryString":"select \n pr_id,\n workstream_name,\n business_objective,\n category as \"Dev Activity\"\n \n from ${test_roadmap_deltas}\n WHERE merged_at BETWEEN DATE '2024-01-01' AND DATE '2024-12-31'","compiled":true,"inline":true},{"id":"bollocks","compiledQueryString":"select \n distinct pr_id,\n business_objective,\n workstream_name,\n category\n\n from (select *\n from eind.dimemsion_data_2024)\n WHERE merged_at BETWEEN DATE '2024-01-01' AND DATE '2024-12-31'","inputQueryString":"select \n distinct pr_id,\n business_objective,\n workstream_name,\n category\n\n from ${test_roadmap_deltas}\n WHERE merged_at BETWEEN DATE '2024-01-01' AND DATE '2024-12-31'","compiled":true,"inline":true},{"id":"test_roadmap_deltas","compiledQueryString":"select *\n from eind.dimemsion_data_2024","inputQueryString":"select *\n from eind.dimemsion_data_2024","compiled":false,"inline":true},{"id":"roadmap_revisions_summaries","compiledQueryString":"select * from csv.roadmap_revisions_role_based_summaries","inputQueryString":"select * from csv.roadmap_revisions_role_based_summaries","compiled":false,"inline":true},{"id":"base_years","compiledQueryString":"select DISTINCT base_year\n from (select * from csv.roadmap_revisions_role_based_summaries)","inputQueryString":"select DISTINCT base_year\n from ${roadmap_revisions_summaries}","compiled":true,"inline":true},{"id":"revision_years","compiledQueryString":"select DISTINCT revision_year\n from (select * from csv.roadmap_revisions_role_based_summaries)","inputQueryString":"select DISTINCT revision_year\n from ${roadmap_revisions_summaries}","compiled":true,"inline":true},{"id":"readers","compiledQueryString":"select DISTINCT reader\n from (select * from csv.roadmap_revisions_role_based_summaries)","inputQueryString":"select DISTINCT reader\n from ${roadmap_revisions_summaries}","compiled":true,"inline":true},{"id":"display_roadmap_revisions_summaries","compiledQueryString":"SELECT\n reader,\n single_sentence_summary,\n four_sentence_summary,\n paragraph_title,\n paragraph_content,\n base_year,\n revision_year,\n CAST(CAST(base_year AS INT) AS TEXT) as base_check,\n CAST(CAST(revision_year AS INT) AS TEXT) as rev_check\n \n FROM (select * from csv.roadmap_revisions_role_based_summaries)\n Where split_part('${inputs.roadmap_years.value}', '/', 1)= base_check\n AND split_part('${inputs.roadmap_years.value}', '/', 2) = rev_check\n AND reader= '${inputs.readers.value}'","inputQueryString":"SELECT\n reader,\n single_sentence_summary,\n four_sentence_summary,\n paragraph_title,\n paragraph_content,\n base_year,\n revision_year,\n CAST(CAST(base_year AS INT) AS TEXT) as base_check,\n CAST(CAST(revision_year AS INT) AS TEXT) as rev_check\n \n FROM ${roadmap_revisions_summaries}\n Where split_part('${inputs.roadmap_years.value}', '/', 1)= base_check\n AND split_part('${inputs.roadmap_years.value}', '/', 2) = rev_check\n AND reader= '${inputs.readers.value}'","compiled":true,"inline":true},{"id":"newDimensions","compiledQueryString":"select * from eind2.code_file_summaries","inputQueryString":"select * from eind2.code_file_summaries","compiled":false,"inline":true},{"id":"newMega","compiledQueryString":"select * from csv.PRDevsByQuarter","inputQueryString":"select * from csv.PRDevsByQuarter","compiled":false,"inline":true},{"id":"roadmapOverviewSelectedDimensions","compiledQueryString":"select \n business_objective_desc as business_Objective,\n broad_theme as roadmap_theme,\n ws_desc as WorkSteam_Description,\n activity1 as Activity\n \n from (select * from eind2.code_file_summaries)\n Where req_year = '2022'","inputQueryString":"select \n business_objective_desc as business_Objective,\n broad_theme as roadmap_theme,\n ws_desc as WorkSteam_Description,\n activity1 as Activity\n \n from ${newDimensions}\n Where req_year = '2022'","compiled":true,"inline":true},{"id":"weekly_display_bar_chart_dim2","compiledQueryString":"SELECT *\nFROM (\n SELECT\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n broad_theme as roadmap_theme,\n COUNT(DISTINCT author) AS active_developers,\n COUNT(DISTINCT pr_id) AS prs_merged\n \n FROM (select * from eind2.code_file_summaries)\n GROUP BY 1, 2\n) sub\nWHERE sub.quarter_start > '1969-12-31'\nORDER BY sub.quarter_start;","inputQueryString":"SELECT *\nFROM (\n SELECT\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n broad_theme as roadmap_theme,\n COUNT(DISTINCT author) AS active_developers,\n COUNT(DISTINCT pr_id) AS prs_merged\n \n FROM ${newDimensions}\n GROUP BY 1, 2\n) sub\nWHERE sub.quarter_start > '1969-12-31'\nORDER BY sub.quarter_start;","compiled":true,"inline":true},{"id":"mega","compiledQueryString":"WITH quarter_devs AS (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n COUNT(DISTINCT author) AS active_developers\n FROM (select * from eind2.code_file_summaries)\n WHERE merged_at IS NOT NULL\n GROUP BY 1\n)\n\n, quarter_themes AS (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n broad_theme AS roadmap_theme,\n COUNT(DISTINCT pr_id) AS prs_merged\n FROM (select * from eind2.code_file_summaries)\n WHERE merged_at IS NOT NULL\n GROUP BY 1, 2\n)\n\nSELECT\n qt.quarter_start,\n qt.roadmap_theme,\n qt.prs_merged,\n qd.active_developers\nFROM quarter_themes qt\nLEFT JOIN quarter_devs qd\n ON qt.quarter_start = qd.quarter_start\nWHERE qt.quarter_start > DATE '1969-12-31'\nORDER BY qt.quarter_start, qt.roadmap_theme;","inputQueryString":"WITH quarter_devs AS (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n COUNT(DISTINCT author) AS active_developers\n FROM ${newDimensions}\n WHERE merged_at IS NOT NULL\n GROUP BY 1\n)\n\n, quarter_themes AS (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n broad_theme AS roadmap_theme,\n COUNT(DISTINCT pr_id) AS prs_merged\n FROM ${newDimensions}\n WHERE merged_at IS NOT NULL\n GROUP BY 1, 2\n)\n\nSELECT\n qt.quarter_start,\n qt.roadmap_theme,\n qt.prs_merged,\n qd.active_developers\nFROM quarter_themes qt\nLEFT JOIN quarter_devs qd\n ON qt.quarter_start = qd.quarter_start\nWHERE qt.quarter_start > DATE '1969-12-31'\nORDER BY qt.quarter_start, qt.roadmap_theme;","compiled":true,"inline":true},{"id":"quaterly_developer_activity","compiledQueryString":"SELECT *\nFROM (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n COUNT(DISTINCT author) AS active_developers\n FROM (select * from eind2.code_file_summaries)\n WHERE merged_at IS NOT NULL\n AND author IS NOT NULL\n GROUP BY 1\n) sub\nWHERE sub.quarter_start > DATE '1969-12-31'\nORDER BY sub.quarter_start;","inputQueryString":"SELECT *\nFROM (\n SELECT\n date_trunc('quarter', merged_at)::date AS quarter_start,\n COUNT(DISTINCT author) AS active_developers\n FROM ${newDimensions}\n WHERE merged_at IS NOT NULL\n AND author IS NOT NULL\n GROUP BY 1\n) sub\nWHERE sub.quarter_start > DATE '1969-12-31'\nORDER BY sub.quarter_start;","compiled":true,"inline":true},{"id":"quater_start_end_dates","compiledQueryString":"SELECT\n \"start\" AS bob,\n \"end\" AS fred,\n\n -- ISO-style strings (yyyy-mm-dd)\n LEFT(CAST(\"start\" AS VARCHAR), 10) AS start_string,\n LEFT(CAST(\"end\" AS VARCHAR), 10) AS end_string,\n\n -- Date-typed columns (ISO)\n CAST(\"start\" AS DATE) AS start_iso,\n CAST(\"end\" AS DATE) AS end_iso,\n\n -- Pretty strings (dd-mm-yyyy)\n strftime(CAST(\"start\" AS DATE), '%d-%m-%Y') AS start_date,\n strftime(CAST(\"end\" AS DATE), '%d-%m-%Y') AS end_date\nFROM csv.quater_data\nWHERE \"year\" = ${parseInt(inputs.year.value, 10)}\nAND \"quarter\" = ${parseInt(inputs.quarter.value, 10)};","inputQueryString":"SELECT\n \"start\" AS bob,\n \"end\" AS fred,\n\n -- ISO-style strings (yyyy-mm-dd)\n LEFT(CAST(\"start\" AS VARCHAR), 10) AS start_string,\n LEFT(CAST(\"end\" AS VARCHAR), 10) AS end_string,\n\n -- Date-typed columns (ISO)\n CAST(\"start\" AS DATE) AS start_iso,\n CAST(\"end\" AS DATE) AS end_iso,\n\n -- Pretty strings (dd-mm-yyyy)\n strftime(CAST(\"start\" AS DATE), '%d-%m-%Y') AS start_date,\n strftime(CAST(\"end\" AS DATE), '%d-%m-%Y') AS end_date\nFROM csv.quater_data\nWHERE \"year\" = ${parseInt(inputs.year.value, 10)}\nAND \"quarter\" = ${parseInt(inputs.quarter.value, 10)};","compiled":false,"inline":true},{"id":"jumbotron","compiledQueryString":"select * from pr_activity_technology_industry_category","inputQueryString":"select * from pr_activity_technology_industry_category","compiled":false,"inline":true},{"id":"cf_all_time_quterly_counts_jumbotron","compiledQueryString":"SELECT\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM (select * from pr_activity_technology_industry_category)\nGROUP BY quarter_start\nORDER BY quarter_start;","inputQueryString":"SELECT\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM ${jumbotron}\nGROUP BY quarter_start\nORDER BY quarter_start;","compiled":true,"inline":true},{"id":"cf_all_time_quterly_counts_programme_jumbotron","compiledQueryString":"SELECT\n owner as programme,\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM (select * from pr_activity_technology_industry_category)\nGROUP BY quarter_start,programme\nORDER BY quarter_start;","inputQueryString":"SELECT\n owner as programme,\n make_date(\n EXTRACT(YEAR FROM merged_at::date)::int,\n ((EXTRACT(QUARTER FROM merged_at::date)::int - 1) * 3) + 1,\n 1\n ) AS quarter_start,\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM ${jumbotron}\nGROUP BY quarter_start,programme\nORDER BY quarter_start;","compiled":true,"inline":true},{"id":"pr_label_counts_selected_quater","compiledQueryString":"SELECT\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM (select * from pr_activity_technology_industry_category)\nWHERE merged_at >= DATE '${quater_start_end_dates[0].start_string}'\nAND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","inputQueryString":"SELECT\n COUNT(pr_id) AS label_count,\n COUNT(DISTINCT pr_id) AS pr_count\nFROM ${jumbotron}\nWHERE merged_at >= DATE '${quater_start_end_dates[0].start_string}'\nAND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","compiled":true,"inline":true},{"id":"pr_label_counts_dim_filter_selected_quater","compiledQueryString":"SELECT\n COUNT(*) AS label_count, -- code-file rows\n COUNT(DISTINCT pr_id) AS pr_count -- unique PRs\nFROM (select * from pr_activity_technology_industry_category)\nWHERE ${inputs.pr_dimensions}\nAND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\nAND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","inputQueryString":"SELECT\n COUNT(*) AS label_count, -- code-file rows\n COUNT(DISTINCT pr_id) AS pr_count -- unique PRs\nFROM ${jumbotron}\nWHERE ${inputs.pr_dimensions}\nAND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\nAND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","compiled":true,"inline":true},{"id":"dim_data_selected_quater_new","compiledQueryString":"select activity,\n industrial,\n technology\n from (select * from pr_activity_technology_industry_category) \n Where merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","inputQueryString":"select activity,\n industrial,\n technology\n from ${jumbotron} \n Where merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","compiled":true,"inline":true},{"id":"dim_data_selected_quater_new_programme","compiledQueryString":"select \n owner as programme,\n activity,\n industrial,\n technology\n from (select * from pr_activity_technology_industry_category) \n Where merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","inputQueryString":"select \n owner as programme,\n activity,\n industrial,\n technology\n from ${jumbotron} \n Where merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","compiled":true,"inline":true},{"id":"bar_chart_base_data2","compiledQueryString":"SELECT merged_at, activity, industrial, technology, owner\n from (select * from pr_activity_technology_industry_category)\n where ${inputs.pr_dimensions}\n AND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","inputQueryString":"SELECT merged_at, activity, industrial, technology, owner\n from ${jumbotron}\n where ${inputs.pr_dimensions}\n AND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }'","compiled":true,"inline":true},{"id":"wekly_display_bar_chart_data2","compiledQueryString":"SELECT\n DATE_TRUNC('week', merged_at)::date AS week_start,\n ${inputs.label_type.value} AS label,\n COUNT(*) AS count \n from (SELECT merged_at, activity, industrial, technology, owner\n from (select * from pr_activity_technology_industry_category)\n where ${inputs.pr_dimensions}\n AND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }')\n \n GROUP BY 1,2\n ORDER BY 1","inputQueryString":"SELECT\n DATE_TRUNC('week', merged_at)::date AS week_start,\n ${inputs.label_type.value} AS label,\n COUNT(*) AS count \n from ${bar_chart_base_data2}\n \n GROUP BY 1,2\n ORDER BY 1","compiled":true,"inline":true},{"id":"activity2","compiledQueryString":"select \n ${inputs.x_axis.value} as xval,\n ${inputs.y_axis.value} as yval,\n count(merged_at) as totals,\n FROM\n (SELECT merged_at, activity, industrial, technology, owner\n from (select * from pr_activity_technology_industry_category)\n where ${inputs.pr_dimensions}\n AND merged_at >= DATE '${quater_start_end_dates[0].start_string}'\n AND merged_at <= DATE '${quater_start_end_dates[0].end_string }')\n WHERE ${inputs.pr_dimensions}\n GROUP BY ${inputs.x_axis.value}, ${inputs.y_axis.value}\n ORDER BY totals desc","inputQueryString":"select \n ${inputs.x_axis.value} as xval,\n ${inputs.y_axis.value} as yval,\n count(merged_at) as totals,\n FROM\n ${bar_chart_base_data2}\n WHERE ${inputs.pr_dimensions}\n GROUP BY ${inputs.x_axis.value}, ${inputs.y_axis.value}\n ORDER BY totals desc","compiled":true,"inline":true},{"id":"owners","compiledQueryString":"select distinct owner from eind.repos","inputQueryString":"select distinct owner from eind.repos","compiled":false,"inline":true},{"id":"repos","compiledQueryString":"select 'All' as label, NULL as value\nunion all\nselect repo as label, repo as value from eind.repos\nwhere owner = '${inputs.owner.value}'","inputQueryString":"select 'All' as label, NULL as value\nunion all\nselect repo as label, repo as value from eind.repos\nwhere owner = '${inputs.owner.value}'","compiled":false,"inline":true},{"id":"roadmap2025","compiledQueryString":"select * from\neind.roadmap_versions_sections","inputQueryString":"select * from\neind.roadmap_versions_sections","compiled":false,"inline":true},{"id":"get_plan_revisions_by_version","compiledQueryString":"select * \n from (select * from\neind.roadmap_versions_sections)\n where roadmap_version = ${inputs.roadmap_versions.value}\n order by \"order\" ASC","inputQueryString":"select * \n from ${roadmap2025}\n where roadmap_version = ${inputs.roadmap_versions.value}\n order by \"order\" ASC","compiled":true,"inline":true},{"id":"roadmap_sections_payload","compiledQueryString":"select heading_markdown as heading,\n content_markdown as content \n from (select * \n from (select * from\neind.roadmap_versions_sections)\n where roadmap_version = ${inputs.roadmap_versions.value}\n order by \"order\" ASC)\n where heading_text in ${inputs.section.value}","inputQueryString":"select heading_markdown as heading,\n content_markdown as content \n from ${get_plan_revisions_by_version}\n where heading_text in ${inputs.section.value}","compiled":true,"inline":true},{"id":"roadmap_sections","compiledQueryString":"select heading_text \n from (select * \n from (select * from\neind.roadmap_versions_sections)\n where roadmap_version = ${inputs.roadmap_versions.value}\n order by \"order\" ASC)","inputQueryString":"select heading_text \n from ${get_plan_revisions_by_version}","compiled":true,"inline":true},{"id":"get_plan_revisions","compiledQueryString":"select * from eind2.code_file_summaries as road_map_revs","inputQueryString":"select * from eind2.code_file_summaries as road_map_revs","compiled":false,"inline":true},{"id":"get_selective_plan_revisions","compiledQueryString":"select requirement_id,\n change_description as requirement_changes,\n completed_2021 as requirement_completed_in_2021,\n milestone_rescheduled_2022 as requirement_reschuled_to_2022,\n changed_2022 as requirment_changed_in_2022,\n current_year as current_year_roadmap_version,\n prior_year as prior_year_roadmap_version\n\n\n from (select * from eind2.code_file_summaries as road_map_revs)","inputQueryString":"select requirement_id,\n change_description as requirement_changes,\n completed_2021 as requirement_completed_in_2021,\n milestone_rescheduled_2022 as requirement_reschuled_to_2022,\n changed_2022 as requirment_changed_in_2022,\n current_year as current_year_roadmap_version,\n prior_year as prior_year_roadmap_version\n\n\n from ${get_plan_revisions}","compiled":true,"inline":true}]}

Eclipse Delivery Overiew & Analysis