Třídová akce

Kód:

2

Tělo:

select
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  '' as Description,
  a.DocDate$Date as Date$Date,
  a.ID as ID,
  a.Firm_ID as FirmID
from LogStoreDocuments a
join DocQueues b ON a.DocQueue_ID=b.id
join Periods c ON a.Period_ID=c.id
where (a.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:ID or Firm_ID=:ID))
 and (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1)  
 and b.DocumentType='33'

Generated by ABRA Software a.s. 27.10.2021 16:35:19