MessageYes that would make a difference too.. depending on what is your AR System backend database there are only certain data types that are supported.. You could get around it by converting that data into a data type that is supported..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 4:51 PM To: [email protected] Subject: Re: View Form Issue ** I believe it is integer but it may be a big int. I suppose that will make a difference. Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 12, 2007 4:47 PM To: [email protected] Subject: Re: View Form Issue How big and what type is that column? ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 3:43 PM To: [email protected] Subject: Re: View Form Issue ** Actually that is not true. There are two columns that can be mapped to the Request ID field that are in both areas however the column that I want is no where to be found. Also, if I query the view in Query Analyzer logged in as Aradmin I can see the column that is not in the view form. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Tuesday, June 12, 2007 4:28 PM To: [email protected] Subject: Re: View Form Issue If it is the Key Field then it will not be selectable in the list of fields. It will be mapped to the view forms Request ID field. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Tuesday, June 12, 2007 1:23 PM To: [email protected] Subject: View Form Issue ** Hello All, ARS 6.3 patch 16 WIN2K SQL2003 I am having a problem creating a View Form from a sql view. This view is a join of several tables in different databases. The JOIN criterion is the record ID for the main table. This also happens to be the only column I cannot see after loading the view into a View From object. I am wondering if anyone has experienced this issue before. Aradmin does have read and write permissions on all columns on all tables but I cannot see this one column. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.14/845 - Release Date: 6/12/2007 6:39 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
