project QadFinancials > class BPeriod > business logic query GetPeriodsOfDateRange
Description
Thiis query has has input 2 dates (mostly a to and from date) and the query returns all periods which cover these dates based on start- and end date
Parameters
| iiCompanyId | integer | Company id |
| itToDate | date | |
| itFromDate | date | |
query condition
each Period where
Period.Company_Id = iiCompanyId AND
(Period.Company_ID = iiCompanyId and
Period.PeriodStartDate >= itFromDate and
Period.PeriodEndDate <= itToDate ) or
(Period.Company_ID = iiCompanyId and
Period.PeriodStartDate <= itFromDate and
Period.PeriodEndDate >= itFromDate ) or
(Period.Company_ID = iiCompanyId and
Period.PeriodStartDate <= itToDate and
Period.PeriodEndDate >= itToDate )
query resultset tqGetPeriodsOfDateRange
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Period.Company_ID | Link to Company |
| tiPeriod_ID | integer | Period.Period_ID | Record ID |
| ttPeriodEndDate | date | Period.PeriodEndDate | End Date |
| tiPeriodMark_ID | integer | Period.PeriodMark_ID | Mark |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| ttPeriodStartDate | date | Period.PeriodStartDate | Start Date |
| tcPeriodStatus | character | Period.PeriodStatus | Status |
| tcPeriodTypeCode | character | Period.PeriodTypeCode | GL Period Type |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
Internal usage
QadFinancials