project BLF > class BResource > business logic query ResourceBySODCategory
Parameters
| iiSODCategoryID | integer | |
| icSODCategoryCode | character | |
| iiResourceID | integer | |
query condition
each Resources where
Resources.Resource_ID = iiResourceID AND
Resources.SODcategory_ID = iiSODCategoryID
first SODCategory (inner-join) where
SODCategory.SODCategory_ID = Resources.SODcategory_ID AND
SODCategory.SODCategoryCode = icSODCategoryCode
query resultset tqResourceBySODCategory
| field name | data type | db field | description |
|---|
| tiResource_ID | integer | Resources.Resource_ID | Record ID |
| tcResourceLabel | character | Resources.ResourceLabel | Resource Label |
| tcResourceType | character | Resources.ResourceType | Type |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tiSODCategory_ID | integer | SODCategory.SODCategory_ID | record ID |
| tcSODCategoryCode | character | SODCategory.SODCategoryCode | SOD category code |
Internal usage
BLF