Objektová akce

Popis:

Získá textovou reprezentaci pro zobrazení

Kód:

1

Tělo:

SELECT
  CASE
    WHEN Firm_ID IS NOT NULL THEN (SELECT Name FROM Firms WHERE ID = A.Firm_ID)  
    WHEN Person_ID IS NOT NULL THEN (SELECT LastName || ' ' || FirstName FROM Persons WHERE ID = A.Person_ID)  
    ELSE ' '
  END 
  || '  '
  || ib_datetostring(ValidFromDate$DATE, 'dd.mm.yyyy')
  || ' - ' 
  || ib_datetostring(ValidToDate$DATE, 'dd.mm.yyyy')
  || '  ' 
  || coalesce(DPD.Code, ' ')
  AS DisplayName
FROM GDPRProcessingPermits A
LEFT JOIN DPDefinitions DPD ON DPD.ID = A.Definition_ID
WHERE A.ID = :OBJID

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