Objektová akce

Kód:

1

Tělo:

select
  d.doctype ||
  (
  Case when d.docqueue_id is not null then
    '/'
  else
    ''
  end
  ) ||
  (
  Case when d.docqueue_id is not null then
    (
    Select
      Name || ' ' || Code
    From
      docqueues dq
    Where
      dq.id = d.docqueue_id
    )
    else
      ''
  end
  )
 As DisplayName from
  docconfirmationbreaks d
where
  d.ID = :OBJID

Generated by ABRA Software a.s. 27.10.2021 16:34:08