project BLF > class BReportVariant > business logic query ReportVariants


Parameters


iiCompanyIdintegerCompany id
iiUserIDinteger
iiRoleIDinteger
iiReportIDinteger
icBusComponentCodecharacter
icBusComponentLabelcharacter


query condition


  each RptRequest where
RptRequest.RptRequestType = 'V' AND
(RptRequest.BusActivity_ID = iiReportID OR
RptRequest.BusActivity_ID = 0 )

      first BusActivity (inner-join) where
BusActivity.BusActivity_ID = RptRequest.BusActivity_ID AND

          first BusComponent (inner-join) where
BusComponent.BusComponent_ID = BusActivity.BusComponent_ID AND
BusComponent.BusComponentCode = icBusComponentCode AND
BusComponent.BusComponentLabel = icBusComponentLabel

      each RptRequestVariant (inner-join) where
RptRequestVariant.Company_Id = iiCompanyId AND
RptRequestVariant.RptRequest_ID = RptRequest.RptRequest_ID AND
(RptRequestVariant.Company_ID = iiCompanyId OR
RptRequestVariant.Company_ID = 0 ) AND
(RptRequestVariant.Role_ID = iiRoleID OR
RptRequestVariant.Role_ID = 0 ) AND
(RptRequestVariant.Usr_ID = iiUserID OR
RptRequestVariant.Usr_ID = 0 )


query resultset tqReportVariants


field namedata typedb fielddescription
tiBusActivity_IDintegerBusActivity.BusActivity_IDRecord ID
tcBusActivityCodecharacterBusActivity.BusActivityCodeCode
tcBusActivityLabelcharacterBusActivity.BusActivityLabelActivity
tiBusComponent_IDintegerBusComponent.BusComponent_IDBusComponent_ID
tcBusComponentCodecharacterBusComponent.BusComponentCodeComponent
tcBusComponentLabelcharacterBusComponent.BusComponentLabelLabel
api annotation:test annotation for BusComponentLabel
tiRole_IDintegerRptRequestVariant.Role_IDRole
tiRptRequest_IDintegerRptRequest.RptRequest_IDRecord ID
tcRptRequestNamecharacterRptRequest.RptRequestNameName
tiUsr_IDintegerRptRequestVariant.Usr_IDUser


Internal usage


BLF
method BControlProperty.GetCustomisedLevels
method BReportVariant.ApiGetVariantInformation