project BLF > class BSODViolationRule1 > business logic query Violations1ByRoleResource
Parameters
| iiRoleID | integer | |
| iiResourceID | integer | |
query condition
each SODViolation1R where
SODViolation1R.Resource_ID = iiResourceID
first SODViolation1 (inner-join) where
SODViolation1.SODViolation1_ID = SODViolation1R.SODViolation1_ID AND
SODViolation1.Role_ID = iiRoleID
query resultset tqViolations1ByRoleResource
| field name | data type | db field | description |
|---|
| tiResource_ID | integer | SODViolation1R.Resource_ID | link to Resource |
| tiRole_ID | integer | SODViolation1.Role_ID | link to Role |
| tiSODViolation1_ID | integer | SODViolation1.SODViolation1_ID | record ID |
Internal usage
BLF