appeals.topic_appeal
Y
Normal
N
1000
100
-
2025/01/28 11:14:23.116
-
2025/01/28 11:14:23.116
Execute SQL script
Table input (subpoena) РФ/осень
Y
Get variables 2 2
Select values 2 2
Y
Select values 2 2
Insert / update (appeals.topic_appeal)
Y
Table input (subpoena) РФ/осень
Get variables 2 2
Y
Execute SQL script
ExecSql
N
1
none
ervu-dashboard
N
N
Y
N
N
DELETE FROM appeals.topic_appeal
WHERE recording_date = current_date
AND schema = 'Ministry'
AND recruitment_id = '${REG_ID}'
336
448
Get variables 2 2
GetVariable
Y
1
none
-1
REG_ID
-1
none
String
-1
VK_ARRAY
-1
none
String
800
448
Insert / update (appeals.topic_appeal)
InsertUpdate
Y
1
none
100
ervu-dashboard
=
schema
schema
=
recruitment_id
REG_ID
appeals
recruitment_id
recruitment_id
N
schema
schema
N
registration
registration
Y
registration_percent
registration_percent
Y
sabpoena
sabpoena
Y
sabpoena_percent
sabpoena_percent
Y
temporary_measures
temporary_measures
Y
temporary_measures_percent
temporary_measures_percent
Y
appear
appear
Y
N
1296
448
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
1008
448
Table input (subpoena) РФ/осень
TableInput
Y
1
none
ervu-dashboard
N
0
SELECT
COALESCE(SUM(appear), 0) appear,
COALESCE(SUM(registration), 0) registration,
COALESCE(SUM(sabpoena), 0) sabpoena,
COALESCE(SUM(temporary_measures), 0) temporary_measures,
COALESCE(
CASE
WHEN SUM(appear) > 0
THEN ROUND((SUM(registration) / SUM(appear) * 100), 2)
ELSE 0
END,
0
) registration_percent,
COALESCE(
CASE
WHEN SUM(appear) > 0
THEN ROUND((SUM(sabpoena) / SUM(appear) * 100), 2)
ELSE 0
END,
0
) sabpoena_percent,
COALESCE(
CASE
WHEN SUM(appear) > 0
THEN ROUND((SUM(temporary_measures) / SUM(appear) * 100), 2)
ELSE 0
END,
0
) temporary_measures_percent,
'${REG_ID}' AS recruitment_id,
'Ministry' AS schema
FROM appeals.topic_appeal
WHERE recruitment_id = ANY ('${VK_ARRAY}')
AND schema = 'Region'
AND recording_date = CURRENT_DATE;
Y
576
448