Třídová akce

Popis:

Najde varianty, které připadají v úvahu pro smazání

Kód:

3

Tělo:

SELECT A.IDs FROM
( 
  SELECT B.ID AS IDs, 1 AS part, B.UPDATEDDATE$DATE AS UPDATEDDATE FROM
    CRPPLANVARIANTS B
  WHERE
    (B.NAME = :InnerName) AND
    (B.USER_ID <> :User_ID) AND 
    (B.VISIBILITYKIND = 2) AND
    (B.ISMAJOR = 'N')
  UNION
  SELECT B.ID AS IDs, 2 AS part, B.UPDATEDDATE$DATE AS UPDATEDDATE FROM
    CRPPLANVARIANTS B
  WHERE
    (B.NAME = :InnerName) AND
    (B.USER_ID = :User_ID) AND
    (B.ISMAJOR = 'N')
) A
ORDER BY
  A.part ASC ,A.UPDATEDDATE DESC

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