project BLF > class BSODViolationRule2 > business logic query ViolationsByUser
Parameters
| iiCompanyId | integer | Company id |
| iiDomainId | integer | |
| iiUserId | integer | |
query condition
each SODViolation2 where
SODViolation2.Company_Id = iiCompanyId AND
SODViolation2.Usr_ID = iiUserId AND
(SODViolation2.Domain_ID = iiDomainId OR
SODViolation2.Domain_ID = 0 ) AND
(SODViolation2.Company_ID = iiCompanyId OR
SODViolation2.Company_ID = 0 )
first Company (outer-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = SODViolation2.Company_ID AND
first Domains (outer-join) where
Domains.Domain_ID = SODViolation2.Domain_ID AND
first Role1 (inner-join) where
Role1.Role_ID = SODViolation2.Role1_ID AND
first Role2 (inner-join) where
Role2.Role_ID = SODViolation2.Role2_ID AND
first SODCategory1 (inner-join) where
SODCategory1.SODCategory_ID = SODViolation2.SODCategory1_ID AND
first SODCategory2 (inner-join) where
SODCategory2.SODCategory_ID = SODViolation2.SODCategory2_ID AND
first SODExclusion (inner-join) where
SODExclusion.SODCategory1_ID = SODViolation2.SODCategory1_ID AND
SODExclusion.SODCategory2_ID = SODViolation2.SODCategory2_ID AND
query resultset tqViolationsByUser
| field name | data type | db field | description |
|---|
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcRole1Name | character | Role1.RoleName | Role Name |
| tcRole2Name | character | Role2.RoleName | Role Name |
| tiSODCategory_ID | integer | SODCategory1.SODCategory_ID | record ID |
| tiSODCategory_ID1 | integer | SODCategory2.SODCategory_ID | record ID |
| tcSODCategoryCode1 | character | SODCategory1.SODCategoryCode | SOD category code |
| tcSODCategoryCode2 | character | SODCategory2.SODCategoryCode | SOD category code |
| tcSODCategoryDescription1 | character | SODCategory1.SODCategoryDescription | SOD category description |
| tcSODCategoryDescription2 | character | SODCategory2.SODCategoryDescription | SOD category description |
| tcSODExclusionLevel | character | SODExclusion.SODExclusionLevel | Exclusion Level |
Internal usage
BLF