Třídová akce

Popis:

Buď NESPOLEHLIVÝ protokol s nejvyšším datem od zadaného data nebo protokol s nejvyšším datem

Kód:

3

Tělo:

SELECT 
A.ID, A.LogDate$DATE, A.StatusCode, A.StatusFromDate$DATE
FROM 
(
SELECT
FIRST 1
ID, LogDate$DATE, StatusCode, StatusFromDate$DATE
FROM
UnreliableFirmLogFirms
WHERE Firm_ID = :Firm_ID
ORDER BY LogDate$DATE DESC
) A

UNION ALL

SELECT 
A.ID, A.LogDate$DATE, A.StatusCode, A.StatusFromDate$DATE
FROM 
(
SELECT
FIRST 1
ID, LogDate$DATE, StatusCode, StatusFromDate$DATE
FROM
UnreliableFirmLogFirms
WHERE Firm_ID = :Firm_ID AND StatusCode=3 AND LogDate$DATE > :LogDateFrom
ORDER BY LogDate$DATE DESC
) A

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