SELECT {FIELDS} FROM
DPAccessRights A
{JOIN}
{WHERE}
{ORDERBY}
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | JUXQ4PCIHEFOJ44J0JJL5JEAHS | Oprávnění k chráněným položkám | |
| DPD | KQASJZLWITX45EGA1Q5MUQIL4G | Definition | Definice ochrany dat |
| SU | 22AHIVDVAVE13C5S00CA141B44 | SUAccesRight | Uživatel |
SELECT {FIELDS} FROM
DPDefinitions A
{JOIN}
WHERE
A.ID=:Parent_ID
ORDER BY
A.Code Collate PXW_CSY
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | KQASJZLWITX45EGA1Q5MUQIL4G | Definice ochrany dat | |
| AR | JUXQ4PCIHEFOJ44J0JJL5JEAHS | AccessRight | Oprávnění k chráněným položkám |
| PF | MJNA253YYHW4VH0I2PCKCOJOEK | ProtectedField | Chráněné položky |
| SU | 22AHIVDVAVE13C5S00CA141B44 | SUAccessRight | Oprávnění k chráněným položkám |
DPD.ID = {:VALUE}
DPD.ID IN ({:LIST})
A.CLSID = {:VALUE}
<<A.FieldName>> LIKE {:VALUE} ESCAPE '~'
A.Parent_ID IN (SELECT DPD.ID FROM DPDefinitions DPD {:WHERE})
DPD.Purpose_ID = {:VALUE}
DPD.Purpose_ID IN ({:LIST})
##CASEOR {:VALUE} #
##1#DPD.DataCategory = 0
##2#DPD.DataCategory = 1
##3#DPD.DataCategory = 2
##END#
DPD.DataProtectionDriver_ID = {:VALUE}
DPD.DataProtectionDriver_ID IN ({:LIST})
DPD.IsActive = {:VALUE}
DPD.Source_ID = {:VALUE}
DPD.Source_ID IN ({:LIST})
DPD.Location_ID = {:VALUE}
DPD.Location_ID IN ({:LIST})
DPD.Solver_ID = {:VALUE}
DPD.Solver_ID IN ({:LIST})
##CASEOR {:VALUE} #
##1#DPD.DataControllerFirm_ID IS NOT NULL
##2#DPD.DataControllerPerson_ID IS NOT NULL
##END#
(DPD.DataControllerFirm_ID IN (SELECT ID FROM Firms WHERE ID={:VALUE} OR Firm_ID={:VALUE}))
(DPD.DataControllerFirm_ID IN (SELECT ID FROM Firms WHERE (ID IN ({:LIST})) OR (Firm_ID IN ({:LIST}))))
DPD.DataControllerPerson_ID = {:VALUE}
DPD.DataControllerPerson_ID IN ({:LIST})
DPD.ID IN (SELECT PF.Parent_ID FROM DPProtectedFields PF {:WHERE})
PF.CLSID = {:VALUE}
<<PF.FieldName>> LIKE {:VALUE} ESCAPE '~'
DPD.ID IN (SELECT AR.Parent_ID FROM DPAccessRights AR {:WHERE})
AR.User_ID = {:VALUE}
AR.User_ID IN ({:LIST})
DPD.ID IN (SELECT DP.Parent_ID FROM DPDataProcessors DP {:WHERE})
##CASEOR {:VALUE} #
##1#DP.Firm_ID IS NOT NULL
##2#DP.Person_ID IS NOT NULL
##END#
(DP.Firm_ID IN (SELECT ID FROM Firms WHERE ID={:VALUE} OR Firm_ID={:VALUE}))
(DP.Firm_ID IN (SELECT ID FROM Firms WHERE (ID IN ({:LIST})) OR (Firm_ID IN ({:LIST}))))
DP.Person_ID = {:VALUE}
DP.Person_ID IN ({:LIST})
SU.Name Collate PXW_CSY
Generated by ABRA Software a.s. 27.10.2021 16:36