aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_params
Parameters
Name
Type
Mode
p_group
text
IN
p_names
text[]
IN (DEFAULT NULL)
Definition
--WITH P AS (FROM unnest(p_names) p_name) SELECT array_agg((SELECT system_params->p_group->>p_name from property_info)) FROM unnest(p_names) p_name --Select array_agg(s.param_value) --from unnest(p_names) p_name left join sys_params s on (s.param_group = p_group::citext) and (s.param_name = p_name::citext) /** *TAX {VAT_RATE, ISSUE_TAX, FORCE_ISSUE_TAX} */