select_recruitments_region(reg)
Y
Normal
0
ORG_ROW
SCM
N
1000
100
-
2024/08/15 14:58:19.728
-
2024/08/15 14:58:19.728
Get variables 3 2
Select values 3 2
Y
Table input/регион
Get variables 3 2
Y
Select values 3 2
Insert / update
Y
Get variables 3 2
GetVariable
Y
1
none
-1
ORG_ROW
-1
none
String
656
208
Insert / update
InsertUpdate
Y
1
none
100
ervu-dashboard
=
recruitment_reg_id
ORG_ROW
ervu_dashboard
vk_array_id
vk_array_id
Y
recruitment_reg_id
recruitment_reg_id
Y
N
992
208
Select values 3 2
SelectValues
Y
1
none
N
ORG_ROW
ORG_ROW
String
-2
-2
false
false
800
208
Table input/регион
TableInput
Y
1
none
ervu-dashboard
N
SELECT
'${ORG_ROW}' AS recruitment_reg_id,
ARRAY(
SELECT idm_id
FROM (
SELECT idm_id
FROM ervu_dashboard.recruitment
WHERE schema = 'Department' AND parent_id = '${ORG_ROW}'
UNION ALL
SELECT idm_id
FROM ervu_dashboard.recruitment
WHERE idm_id = '${ORG_ROW}'
) subquery
) AS vk_array_id
FROM ervu_dashboard.recruitment
WHERE idm_id = '${ORG_ROW}';
Y
528
208