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