00001 #ifndef __AUDIT_TRAIL_H
00002 #define __AUDIT_TRAIL_H
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00076 #define SELECT_AUDIT_TRAIL "\
00077 SELECT at.the_date || ' - Status changed from ' || stat1.name || \
00078 ' to ' || stat2.name || ' by ' || at.login_id \
00079 FROM audit_trail at, status stat1, status stat2 \
00080 WHERE stat1.status_num = at.prev_state \
00081 AND stat2.status_num = at.new_state \
00082 AND at.prev_state <> at.new_state \
00083 AND at.problem_num = %d \
00084 UNION \
00085 SELECT at.the_date || ' - Severity changed from ' || sevr1.name || \
00086 ' to ' || sevr2.name || ' by ' || at.login_id \
00087 FROM audit_trail at, severity sevr1, severity sevr2 \
00088 WHERE sevr1.severity_num = at.prev_sevr \
00089 AND sevr2.severity_num = at.new_sevr \
00090 AND at.prev_sevr <> at.new_sevr \
00091 AND at.problem_num = %d \
00092 ORDER BY at.the_date "
00093
00094
00095 #define PR_SUBMIT_DATE_QUERY "\
00096 SELECT creation_date || ' - Problem report submitted by ' || submitter_id \
00097 FROM problem_report \
00098 WHERE problem_num = %d "
00099
00100 #endif