[441] in Tooltime
Re: Data Conversion and Scopus Web Interface Questions
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Mon Oct 27 11:50:06 1997
In-Reply-To: <v03007800b07a6e6e0c24@[18.177.1.22]>
Date: Mon, 27 Oct 1997 11:50:37 -0500
To: Steven Wade Neiterman <wade@MIT.EDU>
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Hi Steve,
>I believe we also need email as we allow searches on firstname, lastname
>and email.
Okay. Are there other fields in Scopus that need to be uppercase in order
for "query by example" to work, i.e. Department? How can I tell what
fields Scopus is converting to uppercase?
>In general, I would say we should do this, maybe after the conversion. It
>may take more work than it looks. Some email address in Filemaker have the
>domain mit.edu, while others do not (e.g. log 84795 just has the username).
>The warehouse data has the domain listed. If you use the "like" clause in
>sql, you risk getting back more than one record. You could also use
>lastname if one record is returned.
Okay. Sounds like a good solution to me.
>"If this flag is set to 'Yes' and the frozen date has passed, the log is
>automatically marked 'Closed' "
Okay, then we'll definitely need to change the scopus label for this field
to say, which just says "Thaw", to "Close on Thaw". The current label
implies that the log will never thaw if one chooses "no", and it will thaw
on the date set if one chooses "yes". This is very misleading. Who would
make this change? David Ho? You? Me?
>Use the Del key.
Okay...Scopus is lame.
>>2.) We currently have a 'Find Open' button. I think the script associated
>>with that button would be much more usefule if we could restrict frozen
>>logs to those which should not still be frozen. This could be done by
>>extending the where clause for that script as follows:
>>
>> AND (l.mit_status != 'FROZEN' OR (l.mit_status = 'FROZEN'
>> AND upper(l.mit_frozen_flag) != 'no'
>> AND l.mit_frozen_ts <= (SELECT sysdate from dual))
>>
>
>This might be something you can test on the test database. Another options
>is to run a sql query through cron once a night to change the status from
>frozen to something else. This was proposed at one time.
Okay, can you get me started in finding the code?
Cheers,
-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
