Třídová akce

Kód:

10

Tělo:

SELECT
  A.REALBOCLSID CLSID,
  A.FIELDNAME FIELDNAME,
  MAX(A.REFERENCECLSID) REFERENCECLSID,
  MAX(A.REFERENCEFIELDNAME) REFERENCEFIELDNAME
FROM DPPROTECTEDFIELDS A
JOIN DPDEFINITIONS DPD ON DPD.ID = A.PARENT_ID
WHERE 
  DPD.PROCESSSUBJECTRIGHTS = 'A' AND
  DPD.DATAPROTECTIONDRIVER_ID = :DPDriver_ID AND
  A.ISREPORTED = 'A'  
GROUP BY A.REALBOCLSID, A.FIELDNAME
ORDER BY A.REALBOCLSID, A.FIELDNAME

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