Send a description (assuming you are using Oracle type describe <table name> on the SQL prompt) of the table or view you are building this view form.
The data types that are definitely not compatible are db date and time type data.. these would need conversion to integer data so you could create Date and Time fields from it.. If you have date and time related info on that view form, you are definitely looking at a little more work than just type casting.. Joe From: Tommy Morris Sent: Thursday, April 05, 2012 3:44 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: View Form ** Ok no big deal. I’ll look it up in BMC Docs instead of the help file. Unfortunately none of the data types that I’m trying to integrate is supported so I’m stuck anyway. At least it will open a good dialog with the third party software vendor. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, April 05, 2012 2:42 PM To: arslist@ARSLIST.ORG Subject: Re: View Form ** I assure you it is documented somewhere. I just do not recall where. In that documentation I recall that VARCHAR2 and NVARCHAR2 are the supported data types for character fields. If I come across it later I’ll update this thread.. Joe From: Tommy Morris Sent: Thursday, April 05, 2012 2:50 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: View Form ** The data is all nvarchar and numeric. I was just going through the Developer Studio help which is handy but not always helpful. It has nothing about support data types in the view form section. I am converting the fields that I want to utilize in Remedy as I build the view locally. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, April 05, 2012 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: View Form ** 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: arslist@ARSLIST.ORG 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: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 Sent: Thursday, April 05, 2012 11:36 AM Newsgroups: public.remedy.arsystem.general To: 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] On Behalf Of Tommy Morris Sent: Thursday, April 05, 2012 10:27 AM To: 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 tommy.mor...@pinebreeze.com 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>>