Thanks Fred and Joe. I created a new local view (in a separate db object) by pulling from the linked server data. Works great.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, April 05, 2012 10:43 AM To: arslist@ARSLIST.ORG Subject: Re: View Form ** And views are generally preferable as if (for whatever reason) the underlying table gets renamed, you can still keep the same view name, and recreate the view, keeping the view form in the AR System intact.. This is specially the case if the view form is against an internal AR System table, where the table name across environments may not be the same depending on the method you use to promote your customizations or development to prod. Even if the table name is not the same, the view name stays consistent. Joe From: Grooms, Frederick W<mailto:frederick.w.gro...@xo.com> Sent: Thursday, April 05, 2012 11:36 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: View Form ** View forms work against database views or database tables. Sometimes it is better to create local views for linked objects and create the Remedy View form against the local database view than it is to try to create the Remedy View form using the full linked name. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Tommy Morris Sent: Thursday, April 05, 2012 10:27 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: View Form ** Will a view form recognize a database view or does it have to point at a table? I am trying to create a View form against a linked db object view but it does not seem to like the linked name that I am supplying. AR/CMDB/ITSM 7.6.04sp2 SQL 2012 Tommy Morris CMDB Certified Specialist Director of Remedy Integration Services [cid:image001.png@01CD131C.06167700]<http://www.pinebreeze.com/> tommy.mor...@pinebreeze.com<https://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197&URL=mailto%3atommy.morris%40pinebreeze.com> 817.727.1021 – mobile 972.899.2366 - office 972.899.2898 - fax _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<inline: image001.png>>