project BLF > class BResource > business logic query ResourceForChanges
Parameters
query condition
each Resources where
Resources.ResourceURI = icResourceURI
first SODCategory (outer-join) where
SODCategory.SODCategory_ID = Resources.SODcategory_ID AND
query resultset tqResourceForChanges
| field name | data type | db field | description |
|---|
| tiResource_ID | integer | Resources.Resource_ID | Record ID |
| tcResourceLabel | character | Resources.ResourceLabel | Resource Label |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tcSODCategoryCode | character | SODCategory.SODCategoryCode | SOD category code |
Internal usage
BLF