Does it have an ID associated with it that Remedy considers a special or reserved number?
Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brittain, Mark Sent: Wednesday, August 13, 2008 13:59 To: [email protected] Subject: Re: Get all results from a SQL call ** Hi Frank, Thanks for your help. Now I have run into something interesting. I have a few from the database, and a view form in Remedy. When I do to build the table field, I can select any of the field in the view form and put it in the table except the one I want which is the "e_mail_address' field. Any ideas on where to look or what questions to ask the dba? Thanks Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Friday, June 13, 2008 3:26 PM To: [email protected] Subject: Re: Get all results from a SQL call ** 1. Create SQL view of the data from your Remedy database. 2. Create a View form in Remedy using that SQL view 3. Create a table field using that new View. Now when the table refreshes it will have a local copy of all of the records and you can table walk it. On Fri, Jun 13, 2008 at 3:08 PM, Brittain, Mark <[EMAIL PROTECTED]> wrote: Hi All & TGIF, I need to do a SQL query to a database outside of Remedy and gets all of the contact records for a customer and drop them into a field in a ticket. Of course I can get the first or display a list if there are multiple. There has to be a way to get all records that meet the criteria. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Any ideas? Thanks Mark Mark Brittain Remedy Developer NaviSite ESM Operations 315-453-2912 x5418 (Office) 315-317-2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
