project BLF > class BReportRequestBase > business logic query RptRequestPrim


Parameters


iiRequestIDinteger
icRequestNamecharacter
icComponentNamecharacter
icReportNamecharacter
icRequestTypecharacterR (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 namedata typedb fielddescription
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tiRptRequest_IDintegerRptRequest.RptRequest_IDRecord ID
tcRptRequestNamecharacterRptRequest.RptRequestNameName


Internal usage


BLF
method BReportVariant.DataLoadByInput