Look at the documentation surrounding view forms.. they have supported data type.. varchar and nvarchar is not supported.. varchar2 and nvarchar2 in case of unicode is supported. I do not have the documentation handy to quote the exact pages and the text from it but I think its in either the Admin or the configuration guides..
So it’s a case of ‘working as designed’. You may have to do some type casting.. Joe From: Tommy Morris Sent: Thursday, April 05, 2012 1:18 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: View Form ** I spoke too soon. Remedy will only use the Integer fields in this view now. It doesn’t seem to like nvarchar. I will have to convert all the fields when I create the new view. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Thursday, April 05, 2012 10:43 AM To: [email protected] 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 Sent: Thursday, April 05, 2012 11:36 AM Newsgroups: public.remedy.arsystem.general To: [email protected] 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:[email protected]] On Behalf Of Tommy Morris Sent: Thursday, April 05, 2012 10:27 AM To: [email protected] 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 [email protected] 817.727.1021 – mobile 972.899.2366 - office 972.899.2898 - fax _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image001.png>>
