I think some %'s might be needed in the qualification. 'Circuit Ref' LIKE "%S0116715A%" or 'Circuit Ref' LIKE "%" + "S0116715A" + "%"
Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262) 703-7763 | e-mail: tony.worthing...@kohls.com From: "tristan.rop...@t-online.de" <tristan.rop...@t-online.de> To: arslist@ARSLIST.ORG Date: 11/11/2009 01:35 PM Subject: Re: Published Webservice not returning results Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> ** Hi, For my point of view, this qualification does not return any result. Have you tested this in the client (native or web) ? Please react the MidTier Log, as mentioned before ! Cheers Tristan -----Original Message----- Date: Wed, 11 Nov 2009 15:43:10 +0100 Subject: Re: Published Webservice not returning results From: "Grooms, Frederick W" <frederick.w.gro...@xo.com> To: arslist@ARSLIST.ORG ** Can you post what the Mid-Tier shows as the response? Fred From: Action Request System discussion list(ARSList) [ mailto:arsl...@arslist.org] On Behalf Of Andre, Jacques Sent: Wednesday, November 11, 2009 3:47 AM To: arslist@ARSLIST.ORG Subject: Published Webservice not returning results ** Hello List I have an issue where I am publishing a webservice from Remedy. When I try consume this webservice using soapUI , I get no results returned.(Even though the webservice call completes) When I look at the mid-tier log, I can see the results returned, but nothing is returned to soapUI. Webservice :: OpGetlist ---------------------------------------------------------------------------------------------- WSDL Code :: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ " xmlns:urn="urn:Netcool_Incident_Circuit_Search"> <soapenv:Header> <urn:AuthenticationInfo> <urn:userName>netcool</urn:userName> <urn:password>netcool</urn:password> <urn:authentication></urn:authentication> <urn:locale></urn:locale> <urn:timeZone></urn:timeZone> </urn:AuthenticationInfo> </soapenv:Header> <soapenv:Body> <urn:OpGetList> <urn:Qualification>'Circuit Ref' LIKE "S0116715A"</urn:Qualification> <urn:startRecord>0</urn:startRecord> <urn:maxLimit>100</urn:maxLimit> </urn:OpGetList> </soapenv:Body> </soapenv:Envelope> ---------------------------------------------------------------------------------------------- Returned to soapUI :: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ " xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Body> <ns1:OpGetListResponse xmlns="urn:Netcool_Incident_Circuit_Search" xmlns:ns1="urn:Netcool_Incident_Circuit_Search"/> </soapenv:Body> </soapenv:Envelope> ---------------------------------------------------------------------------------------------- Remedy Version:: 7.0.1 Mid-tier Version :: 7.0.1 soauUI Version:: 3.0.1 Many thanks Kind Regards Jacques Andre _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"