main_dashboard.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) 2
Y
Table input (appeal_document) регионы
Get variables 3 2
Y
Execute SQL script
Table input (appeal_document) регионы
Y
Insert / update (main_dashboard.appeals) 2
Execute SQL script 2
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM main_dashboard.appeals
WHERE recording_date = current_date
AND schema = 'Region'
AND recruitment_id = '${MD_ID}'
240
192
Execute SQL script 2
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM main_dashboard.appeals
WHERE recording_date = current_date
AND schema = 'MD_LVL'
AND recruitment_id = '${MD_ID}'
1264
192
Get variables 3 2
GetVariable
Y
1
none
-1
MD_ID
-1
none
String
-1
MD_ARRAY
-1
none
String
672
192
Insert / update (main_dashboard.appeals) 2
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_id
MD_ID
=
schema
schema
main_dashboard
total_appeals
total_appeals
Y
average_consideration
average_consideration
Y
resolved
resolved
Y
average_rating
average_rating
Y
average_to_face
average_to_face
Y
"average_EPGU"
average_epgu
Y
average_to_face_percent
average_to_face_percent
Y
"average_EPGU_percent"
average_epgu_percent
Y
recruitment_id
recruitment_id
N
schema
schema
N
Y
1024
192
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
816
192
Table input (appeal_document) регионы
TableInput
N
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(total_appeals), 0) total_appeals,
COALESCE(SUM(resolved), 0) resolved,
COALESCE(ROUND(AVG(average_consideration) FILTER (where average_consideration!=0),1), 0) average_consideration,
COALESCE(ROUND(AVG(average_rating)FILTER (where average_rating!=0),1), 0) average_rating,
COALESCE(SUM(average_to_face), 0) average_to_face,
COALESCE(SUM("average_EPGU"), 0) average_epgu,
COALESCE(
CASE
WHEN (SUM(average_to_face) + SUM("average_EPGU")) > 0
THEN ROUND((SUM(average_to_face) / (SUM(average_to_face) + SUM("average_EPGU")) * 100), 2)
ELSE 0
END,
0
) average_to_face_percent,
COALESCE(
CASE
WHEN (SUM(average_to_face) + SUM("average_EPGU")) > 0
THEN ROUND((SUM("average_EPGU") / (SUM(average_to_face) + SUM("average_EPGU")) * 100), 2)
ELSE 0
END,
0
) average_epgu_percent,
'${MD_ID}' AS recruitment_id,
'Region' AS schema
FROM main_dashboard.appeals
WHERE recruitment_id = ANY ('${MD_ARRAY}')
AND schema = 'Organization'
AND recording_date = CURRENT_DATE;
Y
448
192