project BLF > class BSODViolationRule2 > business logic query Violations2ByRoleResource
Parameters
| iiCompanyId | integer | Company id |
| iiRoleID | integer | |
| iiResourceID | integer | |
query condition
each SODViolation2R where
SODViolation2R.Resource_ID = iiResourceID
first SODViolation2 (inner-join) where
SODViolation2.Company_Id = iiCompanyId AND
SODViolation2.SODViolation2_ID = SODViolation2R.SODViolation2_ID AND
(SODViolation2.Role1_ID = iiRoleID OR
SODViolation2.Role2_ID = iiRoleID )
query resultset tqViolations2ByRoleResource
| field name | data type | db field | description |
|---|
| tiResource_ID | integer | SODViolation2R.Resource_ID | link to Resource |
| tiRole1_ID | integer | SODViolation2.Role1_ID | link to Role 1 |
| tiRole2_ID | integer | SODViolation2.Role2_ID | link to Role 2 |
| tiSODViolation2_ID | integer | SODViolation2.SODViolation2_ID | record ID |
Internal usage
BLF