project BLF > class BReportTranslation > business logic query TranslationsForReport
Parameters
| iiActivityId | integer | |
| iiComponentID | integer | |
| iiLngID | integer | |
query condition
each ReportTranslation where
(ReportTranslation.ReportBusActivity_ID = iiActivityId OR
ReportTranslation.ReportBusActivity_ID = 0 ) AND
(ReportTranslation.ReportBusComponent_ID = iiComponentID OR
ReportTranslation.ReportBusComponent_ID = 0 )
each TranslationString (outer-join) where
TranslationString.ParentObject_ID = ReportTranslation.ReportTranslation_ID AND
TranslationString.Lng_ID = iiLngID
query resultset tqTranslationsForReport
| field name | data type | db field | description |
|---|
| tiReportTranslation_ID | integer | ReportTranslation.ReportTranslation_ID | Record ID |
| tcReportTranslationCode | character | ReportTranslation.ReportTranslationCode | Report Translation Code |
| tcReportTranslationText | character | ReportTranslation.ReportTranslationText | Text |
| tcTranslationStringText | character | TranslationString.TranslationStringText | Translation |
Internal usage
BLF