20230212 - Validation 검증

IG 저장 전 해당 입력 값에 대한 검증 진행

(:rep_yn = 'N') or

(:rep_yn = 'Y' and (select count(*) from prod_dtlx where dtl_pid = :prod_id) = 0)

Example

SQL Expression

( :JOB = 'SALESMAN' and :COMM is not null ) or ( :JOB != 'SALESMAN' and :COMM is null )

Error message

#COLUMN_HEADER# must have a value only when Job is Salesman.