[453] in Tooltime
Re: Addition to "Find Open" functionality
daemon@ATHENA.MIT.EDU (Peter Ragone)
Thu Oct 30 17:47:59 1997
In-Reply-To: <v0302090ab07eb3905b02@[18.81.0.229]>
Date: Thu, 30 Oct 1997 17:47:49 -0500
To: Debi Fuchs <debi@MIT.EDU>
From: Peter Ragone <pragone@MIT.EDU>
Cc: tooltime@MIT.EDU
Debi,
The quick answer is "maybe". This is because the Scopus GUI will only let
us enter SQL text of a particular length. We've exceeded that length while
trying to design a dialog box for the Find Open button that will let the
user find only the open logs for a particular category. (Meaning find all
open Helpdesk, or all open Mainframe, etc.)
We're working on getting around this artificial limitation of Scopus'
interface because obviously there's no inherent limitation to the logic of
the SQL code. As an example of how we might get around Scopus, perhaps we
can call the SQL code from a line of TCL or something like that. Scopus has
us entering all the 'Where' information in a data field that's only 1 line
high and seems to have a 255 character limit. (Argh).
-Peter
>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
