recruitment_campaign.subpoenas(m_d) Y Normal 0 N 1000 100 - 2024/08/09 13:13:59.825 - 2024/08/09 13:13:59.825 Get variables 4 3 Select values 4 3 Y Select values 4 3 Insert / update (recruitment_campaign.subpoenas) 3 Y Table input (subpoena) осень/регионы Get variables 4 3 Y Execute SQL script Table input (subpoena) осень/регионы Y Insert / update (recruitment_campaign.subpoenas) 3 Execute SQL script 2 Y Execute SQL script ExecSql N 1 none ervu-dashboard N N Y N N DELETE FROM recruitment_campaign.subpoenas WHERE recording_date = current_date AND schema = 'Region' AND recruitment_id = '${MD_ID}' 384 320 Execute SQL script 2 ExecSql N 1 none ervu-dashboard N N Y N N DELETE FROM recruitment_campaign.subpoenas WHERE recording_date = current_date AND schema = 'MD_LVL' AND recruitment_id = '${MD_ID}' 1616 320 Get variables 4 3 GetVariable Y 1 none -1 MD_ID -1 none String -1 MD_ARRAY -1 none String 864 320 Insert / update (recruitment_campaign.subpoenas) 3 InsertUpdate Y 1 none 100 ervu-dashboard = recruitment_id MD_ID = schema schema = spring_autumn spring_autumn recruitment_campaign subpoenas subpoena count_subpoena Y appeared count_appeared Y not_appeared count_not_appeared Y not_ap_good_reason count_not_ap_good_reason Y introduced_measures count_introduced_measures Y ap_not_required count_ap_not_required Y restrictions_applied count_restrictions_applied Y appeared_percent appeared_percent Y not_appeared_percent not_appeared_percent Y not_ap_good_reason_percent not_ap_good_reason_percent Y ap_not_required_percent ap_not_required_percent Y restrictions_applied_percent restrictions_applied_percent Y introduced_measures_percent introduced_measures_percent Y recruitment_id recruitment_id N rest rest Y spring_autumn spring_autumn N count_not_delivery count_not_delivery Y appear_date_is_good appear_date_is_good Y not_delivery_percent not_delivery_percent Y appear_date_is_good_percent appear_date_is_good_percent Y schema schema N N 1344 320 Select values 4 3 SelectValues Y 1 none N MD_ID MD_ID String -2 -2 false false MD_ARRAY MD_ARRAY String -2 -2 false false 1040 320 Table input (subpoena) осень/регионы TableInput Y 1 none ervu-dashboard N 0 SELECT COALESCE(SUM(subpoena), 0) count_subpoena, COALESCE(SUM(appeared), 0) count_appeared, COALESCE(SUM(not_appeared), 0) count_not_appeared, COALESCE(SUM(not_ap_good_reason), 0) count_not_ap_good_reason, COALESCE(SUM(introduced_measures), 0) count_introduced_measures, COALESCE(SUM(ap_not_required), 0) count_ap_not_required, COALESCE(SUM(restrictions_applied), 0) count_restrictions_applied, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(appeared) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) appeared_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(not_appeared) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) not_appeared_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(not_ap_good_reason) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) not_ap_good_reason_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(ap_not_required) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) ap_not_required_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(restrictions_applied) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) restrictions_applied_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(introduced_measures) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) introduced_measures_percent, COALESCE(SUM(rest), 0) rest, COALESCE(SUM(count_not_delivery), 0) count_not_delivery, COALESCE(SUM(appear_date_is_good), 0) appear_date_is_good, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(count_not_delivery) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) not_delivery_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(count_not_delivery) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) not_delivery_percent, COALESCE( CASE WHEN SUM(subpoena) > 0 THEN ROUND((SUM(appear_date_is_good) / SUM(subpoena) * 100), 2) ELSE 0 END, 0 ) appear_date_is_good_percent, '${MD_ID}' AS recruitment_id, spring_autumn, 'Region' AS schema FROM recruitment_campaign.subpoenas WHERE recruitment_id = ANY ('${MD_ARRAY}') AND schema = 'Organization' AND recording_date = CURRENT_DATE GROUP BY spring_autumn; Y 608 320