aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_posting_departments_js
Description
List all departments according to guest’s folio pattern
Parameters
Name
Type
Mode
folio_id
integer
IN
Definition
WITH list AS ( SELECT dp.id, dp.code, dp.name, dp.group_id, dg."name" AS group_name, dp.post_type, dept_type, require_info, coalesce(taxes, '{}') AS taxes, fd.folio_seq FROM folio_details fd LEFT JOIN department dp ON dp.id= fd.dept_id LEFT JOIN department_group dg ON dg.id = dp.group_id WHERE fd.folio_id = $1 AND dp.enabled ) SELECT json_agg(list) FROM list