Oh darn…. I tried again and it is working. It was a rookie mistake on my parenthesis on the huge qualification on that web service. I will go on sit in the corner now. Thank you for the correct syntax Fred
Thank you, Pascale Sterrett Kenavo ar wech all From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fred Grooms via ARSList Sent: Wednesday, August 01, 2018 2:41 PM To: ARSList <arslist@arslist.org> Cc: frederick.w.gro...@verizon.com Subject: RE: [E] Re: web service question Even without a service form you could use a service method in the web service to do the search To use a straight get list method you can structure the Qualification like on the advanced query bar 'Request ID' LIKE "%" + XPATH(/ROOT/getListValueInput/Request ID) + "%" Fred From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, August 1, 2018 3:08 PM To: ARSList <arslist@arslist.org<mailto:arslist@arslist.org>> Subject: [E] Re: web service question At a glace of the requirement the first thing that comes to mind is to create a service form that has workflow to do the heavy lifting. Basically the web service would be written against your service form and accept their inputs. From there your service form would have workflow to find matching records in whatever way needed and then pass results back via the web service. Jason On Wed, Aug 1, 2018 at 2:56 PM, <pascale.sterr...@daimler.com<mailto:pascale.sterr...@daimler.com>> wrote: Hi all, This may be a very simple question, but I can’t find the way to do this. I have a web service that I have exposed. It has 5 different values as inputs. But the application consuming the web service doesn’t know what values is being entered by the users. The requirement is that they are expecting my web services to be able to retrieve the data regardless of what values are being passed in all of the 5 fields that are in the web service. So basically they are going to send me Field a ==> 12345 Field b ==> 12345 Field c ==> 12345 Field d ==> 12345 Field e ==> 12345 And I have to return the data they need with whatever match was found on one or all those matches So I am scratching my head now on how to do this. I have the QBE set to anywhere on these fields but from my understanding that setting only affect the UI and not a web service. I also tried to use the LIKE in the qualification but it will not allow me to add the “%” anywhere to make proper usage of LIKE I am out of ideas. Any help would be greatly appreciated So my question in simple term : How do I make this 'Request ID' LIKE XPATH(/ROOT/getListValueInput/Request ID) Look like ‘1’ LIKE “%12345%” so that it would return what I need 100% custom applications ARS 7.6.4 SP2 MSSQL 2008 Mid Tier 8.1.2 Thank you, Pascale Sterrett If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support. -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ&r=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k&m=U1JtaJcw15kKuFFstop7q-8A-_5olc4oqGAf3xOznc8&s=sjvVjHQ__RvAFjG8hqzLx5MSBQrx0VsXQDpw4YCHfqc&e=> If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support.
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
