Třídová akce

Popis:

Získá všechny neskryté záznamy

Kód:

1

Tělo:

SELECT 
  {FIELDS} 
FROM 
  DPDefinitions A 
  LEFT JOIN DPPurposes P ON P.ID=A.Purpose_ID
  LEFT JOIN GDPRProcessingPermitLocations PPL ON PPL.ID=A.Location_ID
  LEFT JOIN GDPRProcessingPermitSources PPS ON PPS.ID=A.Source_ID
  LEFT JOIN SecurityUsers SU ON SU.ID=A.Solver_ID  
  JOIN SecurityUsers SU1 ON SU1.ID=A.CreatedBy_ID
  LEFT JOIN SecurityUsers SU2 ON SU2.ID=A.CorrectedBy_ID
  LEFT JOIN Firms DCF ON DCF.ID=A.DataControllerFirm_ID
  LEFT JOIN Persons DCP ON DCP.ID=A.DataControllerPerson_ID
  JOIN DPDrivers DPD ON DPD.ID=A.DataProtectionDriver_ID
WHERE 
  A.Hidden = 'N'

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