resily
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
copy_group_okr_nodes
Parameters
Name
Type
Mode
organization_id
bigint
IN
old_okr_term_id
bigint
IN
okr_node_id_mapping
USER-DEFINED
IN
Definition
<<copy_group_okr_nodes>> DECLARE old_group_okr_node RECORD; BEGIN FOR old_group_okr_node IN SELECT group_okr_nodes.* FROM group_okr_nodes INNER JOIN okr_nodes ON okr_nodes.id = group_okr_nodes.okr_node_id AND okr_nodes.okr_term_id = old_okr_term_id INNER JOIN objectives ON objectives.okr_node_id = okr_nodes.id AND objectives.disabled_at IS NULL LOOP EXECUTE $SQL$ INSERT INTO group_okr_nodes ("organization_id", "okr_node_id", "group_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) $SQL$ USING organization_id, (okr_node_id_mapping -> old_group_okr_node.okr_node_id::text)::int8, old_group_okr_node.group_id, old_group_okr_node.created_at, old_group_okr_node.updated_at; END LOOP; END;