project BLF > class BSODCategoryExclusion > business logic query CategoriesAreInConflict
Parameters
| iiCategory1ID | integer | |
| iiCategory2ID | integer | |
query condition
each SODExclusion where
SODExclusion.SODCategory1_ID = iiCategory1ID AND
SODExclusion.SODCategory2_ID = iiCategory2ID
first SODCategory1 (inner-join) where
SODCategory1.SODCategory_ID = SODExclusion.SODCategory1_ID AND
first SODCategory2 (inner-join) where
SODCategory2.SODCategory_ID = SODExclusion.SODCategory2_ID AND
query resultset tqCategoriesAreInConflict
| field name | data type | db field | description |
|---|
| tiSODCategory1_ID | integer | SODExclusion.SODCategory1_ID | link to SOD Category 1 |
| tiSODCategory2_ID | integer | SODExclusion.SODCategory2_ID | link to SOD Category 2 |
| tcSODCategoryCode1 | character | SODCategory1.SODCategoryCode | SOD category code |
| tcSODCategoryCode2 | character | SODCategory2.SODCategoryCode | SOD category code |
| tcSODExclusionLevel | character | SODExclusion.SODExclusionLevel | Exclusion Level |
Internal usage
BLF