project BLF > class BReportRequestBase > business logic query RptRequestPrim
Parameters
| iiRequestID | integer | |
| icRequestName | character | |
| icComponentName | character | |
| icReportName | character | |
| icRequestType | character | R (request) / V (variant) |
query condition
each RptRequest where
RptRequest.RptRequest_ID = iiRequestID AND
RptRequest.RptRequestName = icRequestName AND
RptRequest.RptRequestType = icRequestType
first BusActivity (inner-join) where
BusActivity.BusActivity_ID = RptRequest.BusActivity_ID AND
BusActivity.BusActivityCode = icReportName
first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icComponentName
query resultset tqRptRequestPrim
| field name | data type | db field | description |
|---|
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tiRptRequest_ID | integer | RptRequest.RptRequest_ID | Record ID |
| tcRptRequestName | character | RptRequest.RptRequestName | Name |
Internal usage
BLF