Objektová akce

Kód:

1

Tělo:

select
  d.doctype || '/' ||
  d.confirmatororder || '/' ||
  (
  Case when d.confirmatorrole_id is not null then
    (
    Select
      sr.name
    From
      securityroles sr
    Where
      sr.id = d.confirmatorrole_id)
  else
    (
       Select
       su.name
     From
       securityusers su
     Where
       su.id = d.confirmatorrole_id)
   end
  ) As DisplayName
from
  docconfirmationdefs d
where
  d.ID = :OBJID

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