I've been looking at doing something along these lines also but don't understand well enough how to construct the necessary SQL commands. I have a good SQL reference book and I know how to identify the form and field ID numbers but I'm clearly missing some vital bit of logic or syntax. Can you provide a sample of an SQL command that populates the contents of a change history field into a field on a Remedy form? Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, April 11, 2007 2:58 PM To: [email protected] Subject: Re: Documentation Tool ** Dan, you can create some simple Remedy forms, using menus and workflow that call the SQL commands to populate the fields. I built one in about half a day. Then you could export that data. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fraser Sent: Wednesday, April 11, 2007 12:59 PM To: [email protected] Subject: Documentation Tool ** Does anyone know of a tool (preferably Freeware) that will allow me to scan the Remedy 6.3 Oracle db and show the table relationships (names) to the field ID numbers ? I am working with a Business Intelligence developer to create a "Universe" for reporting out of Remedy and need to provide table reference info to him. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
