Třídová akce

Kód:

3

Tělo:

SELECT 
  PF.CLSID, PF.UpperFieldName
FROM 
  DPProtectedFields PF
  JOIN DPDefinitions DPD ON PF.Parent_ID = DPD.ID
WHERE
  DPD.IsActive = 'A' and DPD.Hidden = 'N'
  and PF.ReferenceCLSID = '00000000000000000000000000'
  and DPD.DataProtectionDriver_ID = '1000000000'
union all
SELECT 
  PF.ReferenceCLSID, PF.ReferenceFieldName
FROM
  DPProtectedFields PF
  JOIN DPDefinitions DPD ON PF.Parent_ID = DPD.ID
WHERE
  PF.ReferenceCLSID <> '00000000000000000000000000' 
  and DPD.IsActive = 'A' and DPD.Hidden = 'N'
  and DPD.DataProtectionDriver_ID = '1000000000'

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