recruitment_campaign.appeals(m_d)
Y
Normal
0
N
1000
100
-
2024/08/02 11:56:22.507
-
2024/08/02 11:56:22.507
Get variables 3 2
Select values 3 2
Y
Select values 3 2
Insert / update (main_dashboard.appeals)
Y
Table input (appeal_document) регионы
Get variables 3 2
Y
Execute SQL script
Table input (appeal_document) регионы
Y
Insert / update (main_dashboard.appeals)
Execute SQL script 2
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM recruitment_campaign.appeals
WHERE recording_date = current_date
AND schema = 'Region'
AND recruitment_id = '${MD_ID}'
304
352
Execute SQL script 2
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM recruitment_campaign.appeals
WHERE recording_date = current_date
AND schema = 'MD_LVL'
AND recruitment_id = '${MD_ID}'
1360
352
Get variables 3 2
GetVariable
Y
1
none
-1
MD_ID
-1
none
String
-1
MD_ARRAY
-1
none
String
736
352
Insert / update (main_dashboard.appeals)
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_id
MD_ID
=
schema
schema
recruitment_campaign
total_appeals
total_appeals
Y
average_consideration
average_consideration
Y
resolved
resolved
Y
not_resolved
not_resolved
Y
not_resolved_percent
not_resolved_percent
Y
average_rating
average_rating
Y
resolved_percent
resolved_percent
Y
recruitment_id
recruitment_id
N
spring_autumn
spring_autumn
N
schema
schema
N
N
1104
352
Select values 3 2
SelectValues
Y
1
none
N
MD_ID
MD_ID
String
-2
-2
false
false
MD_ARRAY
MD_ARRAY
String
-2
-2
false
false
880
352
Table input (appeal_document) регионы
TableInput
N
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(total_appeals), 0) total_appeals,
coalesce(ROUND(avg(average_consideration) FILTER (where average_consideration!=0),1),0) as average_consideration,
COALESCE(SUM(resolved), 0) resolved,
COALESCE(SUM(not_resolved), 0) not_resolved,
COALESCE(
CASE
WHEN SUM(total_appeals) > 0
THEN ROUND((SUM(not_resolved) / SUM(total_appeals) * 100), 2)
ELSE 0
END,
0
) not_resolved_percent,
coalesce(ROUND(avg(average_rating) FILTER (where average_rating!=0),1),0) as average_rating,
COALESCE(
CASE
WHEN SUM(total_appeals) > 0
THEN ROUND((SUM(resolved) / SUM(total_appeals) * 100), 2)
ELSE 0
END,
0
) resolved_percent,
'${MD_ID}' AS recruitment_id,
spring_autumn,
'Region' AS schema
FROM recruitment_campaign.appeals
WHERE recruitment_id = ANY ('${MD_ARRAY}')
AND schema = 'Organization'
AND recording_date = CURRENT_DATE
GROUP BY spring_autumn;
Y
512
352