egdb3_11_7
.actor
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
get_cascade_setting_batch(setting_names text[], org_id integer, user_id integer, workstation_id integer)
Parameters
Name
Type
Mode
setting_names
text[]
IN
org_id
integer
IN
user_id
integer
IN
workstation_id
integer
IN
Definition
-- Returns a row per setting matching the setting name order. If no -- value is applied, NULL is returned to retain name-response ordering. DECLARE setting_name TEXT; summary actor.cascade_setting_summary; BEGIN FOREACH setting_name IN ARRAY setting_names LOOP SELECT INTO summary * FROM actor.get_cascade_setting( setting_Name, org_id, user_id, workstation_id); RETURN NEXT summary; END LOOP; END;