recruitment_campaign.appeals
Y
Normal
0
N
1000
100
-
2024/08/02 11:56:22.507
-
2024/08/02 11:56:22.507
Get variables 2 2
Select values 2 2
Y
Table input (appeal_document) РФ/осень
Get variables 2 2
Y
Select values 2 2
Insert / update (main_dashboard.appeals)
Y
Execute SQL script
Table input (appeal_document) РФ/осень
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 = 'Ministry'
AND recruitment_id = '${REG_ID}'
208
256
Get variables 2 2
GetVariable
Y
1
none
-1
REG_ID
-1
none
String
-1
VK_ARRAY
-1
none
String
656
256
Insert / update (main_dashboard.appeals)
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_id
REG_ID
=
spring_autumn
spring_autumn
=
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
256
Select values 2 2
SelectValues
Y
1
none
N
REG_ID
REG_ID
String
-2
-2
false
false
VK_ARRAY
VK_ARRAY
String
-2
-2
false
false
864
256
Table input (appeal_document) РФ/осень
TableInput
Y
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,
'${REG_ID}' AS recruitment_id,
spring_autumn,
'Ministry' AS schema
FROM recruitment_campaign.appeals
WHERE recruitment_id = ANY ('${VK_ARRAY}')
AND schema = 'Region'
AND recording_date = CURRENT_DATE
GROUP BY spring_autumn;
Y
416
256