My memory isn't what it used to be, but I believe you can change the view pointers at the database level by changing the tablename in the SCHEMA_VIEW table, then restarting the system. You'll see the underlying tables for your view fields in this table. No Warranty Implied! :) Rob Tucker New Edge Networks
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 27, 2008 3:09 PM To: [email protected] Subject: Re: Updating view forms ** I don't know of a way to change the Remedy view location other than exporting to a def, modifying the def, deleting the form and re-importing from the modified def. Importing in place (without deleting the form) might work. Have you tried creating a local Remedy db view of the remote data. Basically drop the synonym and do: Create or Replace View MYSCHEMA.MYVIEW as select * from [EMAIL PROTECTED]; No changes to Remedy will then be necessary. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jill E Sent: Wednesday, February 27, 2008 5:00 PM To: [email protected] Subject: Updating view forms Greetings, In an ARS 7.0.1 / RHEL4 64bit / Oracle 10g environment, I created a view form to look at a view of another schema in the same database as Remedy. That schema was moved to another Oracle database so now a DB link must be employed. This is fine except that I need to update the view form in ARS so that it knows to look in the new location. How can I update the view form definition to look at a different database location? Specifically, I want to change Form Properties > View Information > Table Name value from MYSCHEMA.MYVIEW to [EMAIL PROTECTED], Field Properties > Database tab > View Information > Table value, or use some other means to update the view form to use a new table name value. I tried a workaround by creating a synonym, which works fine in SQLPlus for running queries as aradmin like "select * from MYSCHEMA.MYVIEW where id='foo'" but each time I open the view form in Remedy Administrator, the error "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)" is reported and I am not able to get AR to use the synonym, even to create new view form, like I am with SQLPlus. I've found old bugs relating to synonyms, but I am not tied to using this approach to solve the problem anyway. Thanks for any advice you can offer! Jill Anderson __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
