SELECT A.ID
FROM ServiceDocuments A
WHERE
(A.ObjectKind = :KIND) AND
(upper(A.ServicedObjectText collate PXW_CSY) LIKE (upper('{ATxtName}')) ESCAPE '~') AND
(upper(A.ServicedObjectSerialNr collate PXW_CSY) LIKE (upper('{ATxtId}')) ESCAPE '~')
ORDER BY
A.DocDate$DATE desc, A.OrdNumber descGenerated by ABRA Software a.s. 27.10.2021 16:35:46