Please help me
Hi, Requirement When user enters a value in a field in Remedy form and press Enter,pull matching records from an external system and display them in a table field. External System:Telecordia Granite/Oracle Additional information 1.The matching records can be many records(50-100) 2.Direct interaction with external system database is not supported. 3.Not required to store returned matching records in Remedy system. Proposed solution I proposed view form based solution,but the external team is not supporting it. Please help me if you know any other solution for this requirement.Thanks. Regards Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Hi, There are OOTB APIs like Java API, .NET API and C API. I belive you can achive the required functionality with these APIs. ** ** ** ** *Regards,* *Mahendra Mahalkar * On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew wrote: > Hi, > > Requirement > > When user enters a value in a field in Remedy form and press Enter,pull > matching records from an external system and display them in a table field. > > External System:Telecordia Granite/Oracle > > Additional information > > 1.The matching records can be many records(50-100) > > 2.Direct interaction with external system database is not supported. > > 3.Not required to store returned matching records in Remedy system. > > Proposed solution > > I proposed view form based solution,but the external team is not > supporting it. > > Please help me if you know any other solution for this requirement.Thanks. > > Regards > Robin > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Hi Robin, Is there a specific reason for not supporting the View Form? You could use the APIs as Mahendra suggested, or you could create a stored procedure on your ARSystem database to pull the data into a temporary table and have a view form of that. Performance won't be a good as a View Form of the external table but if only 50-100 records then it may be acceptable. Regards, Chris -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Robin Mathew Sent: 04 July 2013 09:34 To: arslist@ARSLIST.ORG Subject: Please help me Hi, Requirement When user enters a value in a field in Remedy form and press Enter,pull matching records from an external system and display them in a table field. External System:Telecordia Granite/Oracle Additional information 1.The matching records can be many records(50-100) 2.Direct interaction with external system database is not supported. 3.Not required to store returned matching records in Remedy system. Proposed solution I proposed view form based solution,but the external team is not supporting it. Please help me if you know any other solution for this requirement.Thanks. Regards Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Hi Robin, As per your requirement, I would suggest remedy Web Services. Case Study - 1. When user will hit enter on field, push entry record in one of the custom form lets say "A" 2. Write consume third party web service (Telecordia Granite/Oracle) on form "A" with the help of filter. 3. As Web service consume result - you can create single or multiple records in second staging form say "B" Please refer BMC Third Party Integration Guide for more details. 4. Create table field on form which will visible to end user i.e where end user hit enter. 5. Point table field to Form "B" and refresh it using same workflow. This is very convinient way in such requirement as stated above. I hope this will help you. Thanks Kiran Patil On Thu, Jul 4, 2013 at 2:04 PM, Robin Mathew wrote: > Hi, > > Requirement > > When user enters a value in a field in Remedy form and press Enter,pull > matching records from an external system and display them in a table field. > > External System:Telecordia Granite/Oracle > > Additional information > > 1.The matching records can be many records(50-100) > > 2.Direct interaction with external system database is not supported. > > 3.Not required to store returned matching records in Remedy system. > > Proposed solution > > I proposed view form based solution,but the external team is not > supporting it. > > Please help me if you know any other solution for this requirement.Thanks. > > Regards > Robin > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > -- *Regards* * **Kiran Patil* *Cognizant Technology Solutions* *Pune, India* *Mob No: +91 989 037 7125 * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
is net API supported ? Eg creating a record. This seemed to come and go over the last 12 years Sent from my iPhone On Jul 4, 2013, at 4:41 AM, Mahendra Mahalkar wrote: > ** > Hi, > There are OOTB APIs like Java API, .NET API and C API. I belive you can > achive the required functionality with these APIs. > > > > > > Regards, > Mahendra Mahalkar > > > On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew wrote: >> Hi, >> >> Requirement >> >> When user enters a value in a field in Remedy form and press Enter,pull >> matching records from an external system and display them in a table field. >> >> External System:Telecordia Granite/Oracle >> >> Additional information >> >> 1.The matching records can be many records(50-100) >> >> 2.Direct interaction with external system database is not supported. >> >> 3.Not required to store returned matching records in Remedy system. >> >> Proposed solution >> >> I proposed view form based solution,but the external team is not supporting >> it. >> >> Please help me if you know any other solution for this requirement.Thanks. >> >> Regards >> Robin >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Hi, Anything using the C or Java API is supported from the servers standpoint. The .net-api is a wrapper around a supported API, so if your program manages to submit records, the submitted record will be a supported record. If the .net-api lacks functionality, which you would quickly find out. There is no guarantee that it will be added. There is also no guarantee of new versions. Old (current) versions of the API will work against newer servers. At least two major releases will work, but probably a lot more than two versions. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > is net API supported ? Eg creating a record. This seemed to come and go over > the last 12 years > > Sent from my iPhone > > On Jul 4, 2013, at 4:41 AM, Mahendra Mahalkar > wrote: > >> ** >> Hi, >> There are OOTB APIs like Java API, .NET API and C API. I belive you can >> achive the required functionality with these APIs. >> >> >> >> >> >> Regards, >> Mahendra Mahalkar >> >> >> On Thu, Jul 4, 2013 at 12:34 PM, Robin Mathew >> wrote: >>> Hi, >>> >>> Requirement >>> >>> When user enters a value in a field in Remedy form and press Enter,pull >>> matching records from an external system and display them in a table field. >>> >>> External System:Telecordia Granite/Oracle >>> >>> Additional information >>> >>> 1.The matching records can be many records(50-100) >>> >>> 2.Direct interaction with external system database is not supported. >>> >>> 3.Not required to store returned matching records in Remedy system. >>> >>> Proposed solution >>> >>> I proposed view form based solution,but the external team is not supporting >>> it. >>> >>> Please help me if you know any other solution for this requirement.Thanks. >>> >>> Regards >>> Robin >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Robin, I would suggest to create a vendor form to fetch records from external source, you will have to write your own ardbc plugin (c or java and you must implement GetListEntryWithFields in plugin). Once vendor form is in place , write an active link that executes on enter and performs set field action. For active link set field action, read the data from this vendor form and select option to display list for multiple record match. regards Ranjit On Thu, 7/4/13, Robin Mathew wrote: Subject: Please help me To: arslist@ARSLIST.ORG Date: Thursday, July 4, 2013, 2:04 PM Hi, Requirement When user enters a value in a field in Remedy form and press Enter,pull matching records from an external system and display them in a table field. External System:Telecordia Granite/Oracle Additional information 1.The matching records can be many records(50-100) 2.Direct interaction with external system database is not supported. 3.Not required to store returned matching records in Remedy system. Proposed solution I proposed view form based solution,but the external team is not supporting it. Please help me if you know any other solution for this requirement.Thanks. Regards Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Please help me
Thanks everyone for your inputs. Ranjit, I am looking into your proposal.Thanks once again. Regards Robin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"