You could also do a database query to get the list: select * >From filter where filterid in ( select filterid FROM filter_set where assignLong like '%<URL to search>%' )
Shawn Scutchings From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Friday, June 13, 2014 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: Finding all filters and Escalations that contain a web service set fields ** Perhaps you're solving the wrong problem. A web service - from the HTTP server side - is just a http/https call. If they are changing their endpoint, I think they should be able to put in a re-direct. I've never actually tested this, but it makes sense with what I know of web servers. For example, if the current address for the web service is http://someserver/myservice/etc they can probably put in a server-side redirect to send all queries to that to whatever the new URL is. But let's say that doesn't work out for whatever reason. The exceptionally manual way to do this is... 1. Export all filters, escalations 2. Put the def file in Textpad (or your favorite text editor) 3. start searching for ARSYS.ARF.WEBSERVICE, or the URL of the web service in question 4. Note the object name for each one you find embedded 5. Change as necessary in Dev Studio Unfortunately, I don't think you can do a search and replace in the DEF file, because the URL's are embedded character strings. It will look like this: set-field : 0\>\101\4\117\https://<url removed>/arsys/services/ARService?server=<servername removed>&webService=<WS name remove> You can try it, but I suspect - unless you are very lucky and the new and old URL's ahve the same # of characters - that it won't work. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Friday, June 13, 2014 1:46 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Finding all filters and Escalations that contain a web service set fields ** OK, I have a major challenge ahead of me, I have a Remedy 7.6.04 environment that is a fully custom app, no Out of the Box apps, that interacts with a third party application via Web Services calls. There are hundreds of filters/escalations involved, and the third party app is changing the URL it exposes for Web Service Calls. I need to find all of the filters and escalations that make web service calls so that I can change those URL endpoints. Does anyone have a good way to search for objects that have a Set Fields Web Service operation and generate a list? I don't have Migrator or anything other third party tools like that at my disposal. What would be great is to be able to generate a Working List in Dev Studio, but I really haven't had any luck getting the search feature to work, Ideas? Paul Campbell | Systems Architect | | Avaya Client Services | | 678-421-5342 | Web Conference<https://collaborate.avaya.com/aacpa/?participantCode=4215342> | Audio Conference +1-513-228-8888 code: 4215342 Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn't have deadlines, we'd stagnate. Walt Disney ________________________________ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4570 / Virus Database: 3955/7631 - Release Date: 06/06/14 Internal Virus Database is out of date. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"