Třídová akce

Kód:

1

Tělo:

SELECT
  (DQ.Code || '-' || CAST(SD.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  SD.ID
FROM
  storedocuments2 A
  JOIN StoreDocuments SD ON A.parent_id = SD.id
  JOIN docqueues DQ ON DQ.id = SD.docqueue_id
  join Periods P ON P.ID = SD.period_id
WHERE
  A.id = :RDocumentRowID

Generated by ABRA Software a.s. 27.10.2021 16:34:11