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