Objektová akce

Kód:

3

Tělo:

SELECT 
  DISTINCT SD.DocumentType, B.Parent_id 
FROM 
  LogStoreDocuments2 A 
  JOIN StoreDocuments2 B ON A.StoreDocRow_ID = B.ID 
  JOIN StoreDocuments SD ON B.Parent_ID = SD.ID
WHERE 
  A.Parent_ID = :OBJID

UNION ALL

select DISTINCT 'MI', MASTERDOCUMENT_id
FROM 
  LogStoreDocuments
WHERE
  masterdocclsid = 'KGKSPD2IGUXOV3V2JN0IILOSRG' and
  ID = :OBJID  

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