Suppress 처리 시 SQL Query 적용

INSERT INTO audithistory
            (issue_id,
             attrguid,
             seqnumber,
             projectversion_id,
             audittime,
             oldvalue,
             newvalue,
             username,
             conflict)
VALUES      (2098,
             '22222222-2222-2222-2222-222222222222',
             0,
             2,
             1681520831681,
             'false',
             'true',
             'admin',
             'N');

INSERT INTO auditcomment
            (issue_id,
             seqnumber,
             audittime,
             commenttext,
             username)
VALUES      (2098,
             0,
             1681520831678,
             'suppress test',
             'admin');

UPDATE issue
SET    revision = 1,
       audited = 'N',
       auditedtime = NULL,
       suppressed = 'Y',
       issuestatus = 'Under Review',
       issuestate = 'Open Issue',
       username = NULL,
       friority = 'Critical',
       enginepriority = NULL
WHERE  projectversion_id = 2
       AND id = 2098;
위로 스크롤