Třídová akce

Kód:

13

Tělo:

SELECT {FIELDS} FROM UserDefinedForms A
LEFT JOIN UserDefinedForms2 B ON A.ID = B.Form_ID AND (B.User_ID = :User_ID OR B.User_ID IS NULL)
JOIN SYS$DecideTableBool C ON (((C.IValue = 1) AND (A.Owner_ID IS NULL)) OR ((C.IValue = 0) AND (A.Owner_ID IS NOT NULL)))
LEFT JOIN SecurityUsers D ON D.ID = A.CreatedBy_ID
LEFT JOIN SecurityUsers E ON E.ID = A.CorrectedBy_ID
WHERE A.Owner_ID IS NULL OR A.Owner_ID = :Owner_ID

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