[452] in Tooltime
Addition to "Find Open" functionality
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Thu Oct 30 17:36:09 1997
Date: Thu, 30 Oct 1997 17:36:01 -0500
To: pragone@MIT.EDU, dho@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Peter and David,
For the "find open" scripts, can we also augment them to (1) disclude
"Frozen" logs which are marked "Close on Thaw" or for which the frozen date
is greater than todays date, as well as to (2) disclude "Taken" logs not
taken by the current user, i.e.
SELECT l.mit_log_id "Log", l.mit_status "Status",
l.mit_category "Category", l.mit_pri_lastname "Last Name",
l.mit_pri_firstname "First Name" ,
substr(to_char(l.mit_created_ts,'YYYY/MM/DD HH24:MI:SS'),1,20)
"Created On", substr(l.mit_summary,1,80) "Summary"
FROM mit_logs l, mit_lk_status s
WHERE l.mit_status = s.mit_status and s.mit_status_flag=1
and (not( l.mit_status = 'CLOSED' or l.mit_status != 'CANCEL'
or (l.mit_status = 'FROZEN' and (l.mit_frozen_flag='Yes'
or l.mit_frozen_ts >(SELECT sysdate from dual)))
or (l.mit_status = 'TAKEN' and mit_taken_by !=
(SELECT userid FROM profiles
WHERE login_name=(SELECT user from dual))))
ORDER BY s.mit_weight desc, l.mit_modified_ts, l.mit_log_id asc
Thanks,
-Debi
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
