project BLF > class BReportVariant > business logic query ReportVariants
Parameters
| iiCompanyId | integer | Company id |
| iiUserID | integer | |
| iiRoleID | integer | |
| iiReportID | integer | |
| icBusComponentCode | character | |
| icBusComponentLabel | character | |
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 name | data type | db field | description |
|---|
| tiBusActivity_ID | integer | BusActivity.BusActivity_ID | Record ID |
| tcBusActivityCode | character | BusActivity.BusActivityCode | Code |
| tcBusActivityLabel | character | BusActivity.BusActivityLabel | Activity |
| tiBusComponent_ID | integer | BusComponent.BusComponent_ID | BusComponent_ID |
| tcBusComponentCode | character | BusComponent.BusComponentCode | Component |
| tcBusComponentLabel | character | BusComponent.BusComponentLabel | Label |
| api annotation: | | test annotation for BusComponentLabel |
| tiRole_ID | integer | RptRequestVariant.Role_ID | Role |
| tiRptRequest_ID | integer | RptRequest.RptRequest_ID | Record ID |
| tcRptRequestName | character | RptRequest.RptRequestName | Name |
| tiUsr_ID | integer | RptRequestVariant.Usr_ID | User |
Internal usage
BLF