aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_get_ooo_desc
Parameters
Name
Type
Mode
ooo_id
integer
IN
desc_format
integer
IN (DEFAULT 0)
Definition
select case desc_format when 1 then format('%s (%s - %s, %s)', o.ooo_type, to_char(o.start_date, 'dd Mon yyyy'), to_char(o.end_date, 'dd Mon yyyy'), rs.name) else format('Room %s: %s, %s - %s, %s', r.room_number, o.ooo_type, to_char(o.start_date, 'dd Mon yyyy'), to_char(o.end_date, 'dd Mon yyyy'), rs.name) end from out_of_order o left join room r on r.id = o.room_id left join ooo_reason rs on rs.id = o.reason_id where o.id = $1