aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_batch_report_options
Parameters
Name
Type
Mode
batch_item_id
integer
IN
Definition
declare report_id int; option_values jsonb; report_options jsonb; begin select * from dblink(fn_conn_authen(), format('Select report_id, option_values from batch_report_items where item_id = %L', batch_item_id)) as R(report_id int, option_values jsonb) into report_id, option_values; return sp_get_reports_option_js(report_id, true, option_values); end