I have ran into this one before. What I did was convert the database date
field to a character field using the dbconversions.
To implement it.
1) Create a database view of the database table, with an additional column
which has the character conversion.
Use the following syntax to convert the Oracle date to a character. This one
is nice since it does the timezone conversion for you.
select tochar(newtime(TODATE('01/01/1970 00:00:00','MM/DD/YYYYHH24:MI:SS')+
(dateint/(60*60*24)), 'GMT', 'PDT'), 'MM/DD/YY HH24:MI:SS') from testnum ;
2) Create the Remedy View against the database view.
Check the Remedy KB #311 for more details on the conversion.
-jeff
-----Original Message-----
From: erashid [SMTP:erashid@WCOM.CA]
Sent: Tuesday, December 31, 2002 9:09 AM
To: ARSLIST
Cc: erashid
Subject: Re: 5.x Question
Dear Baljinder,
REMEDY CONSTRAINT :
According to the document on view forms, Remedy does not
recognize date datetypes. This probably explains why the
data field does not appear as part of the field selection.
A SOLUTION :
You can try creating a complementary varchar2 or number
field (which Remedy does support) to redundantly store the
date information and have it appear on the form.
You can use a database trigger if you wish to keep all of
this at the db end instead of having a solution mix of db
and Remedy.
Sincerely,
El-Noor
On Mon, 30 Dec 2002 15:48:47 -0500
Baljinder Samrai wrote:
>Hello,
>
>I have a question and would like to get some responses on
>a possible solution.
>
>I have created a view form for an oracle table. However,
>I am not able to select an oracle date field to be
>visible on the view form in our remedy application. Does
>anyone have any ideas on how it may be possible to view
>an oracle date field in a Remedy view form.
>
>
>
>Thank you,
>
>Baljinder Samrai
>Systems Analyst
>Adelphia Communications Corporation
>716-819-6137 (Office)
>"Success is mandatory"
>
>
>
>
>You may control your subscription options, including
>UNSUBSCRIBE,and ACCESS THE ARCHIVES at
>http://www.ARSLIST.org. For ARSList support, please send
>eMail to support@arslist.org
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE
ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to
support@arslist.org
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
Previous Topic
Index