Alan,
Assuming your ARS server is using Oracle and that the Oracle table in question does or could have a unique key suitable for use as an ARS 'Request ID' field then I would think about using an ARS View form. Or you can have Filters on a normal "ARS form" that updates/maintains data in the "other Oracle table" for the users too. (So the Oracle table is a "Legacy" thing that you support with "Direct SQL" actions in workflow and it is "outside" ARS's primary function/role.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/13/06, Nicoll, Alan <[EMAIL PROTECTED]> wrote:
** Yes. I've got a request to recreate a current application in Remedy. The current application has an Oracle table at its base that uses an Oracle Date type field and it has many reports and other applications linked to it that use that Date field. Is there any way I can recreate that structure using Remedy as the front end? -Alan (Nick) Nicoll BGO/PSG/WFBU/DocuSP Problem Management System Administrator 8*823-5081 ESC1-615 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nicoll, Alan Sent: Wednesday, July 12, 2006 7:21 PM To: [email protected] Subject: Is it possible to create and write an Oracle DATE type field from Remedy? If so, how is it done? Alan E (Nick) Nicoll DocuSP Problem System Administrator Xerox Corporation Xerox Centre Drive, MS: ESC1-615 El Segundo, CA 90245
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
