There shouldn't be ... Have you looked to see what that 1 record has different? Could it be something to do with the login used?
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 1:08 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries This worked! Thanks! NOW, back to the original problem I was trying to research. When I run this query off of the webservices, I get 38 records back, but on WUT or Midtier, I get 37 records back. (just like my customer said) Is there any reason why the same query would bring back different results off of the Webservice vs. the WUT or Midtier? Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, April 24, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Try encoding the < <urn:Qualification> 'Change Status' <= "NOT COMPLETED" </urn:Qualification> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Thanks Fred, I tried your suggestion and I'm still getting this error. I even tried: <urn:Qualification> 'Change Status' <= "NOT COMPLETED" </urn:Qualification> and I get the error. When I change the <= to >= it's fine. I think it has something to do with the < symbol. It's like it has to be matched with an opposite >. This is in SOAP. The whole reason why I'm testing this is because my customer is getting back different data than I am in the WUT, so I thought I would test his query in SOAP to see what records would come back, but I can't even test it if SOAP doesn't like the < symbol.... Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, April 24, 2012 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries If the field is a Date/Time field I would think that the web service would expect it to be in a valid XML Date/Time format. The XML Date/Time format is YYYY-MM-DDThh:mm:ss.0000-05:00 (http://www.w3schools.com/schema/schema_dtypes_date.asp) With a web service try 'Start Date and Time' <= "2012-04-23T15:30:00" AND 'Change Status' = "CANCELED" Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 8:25 AM To: arslist@ARSLIST.ORG Subject: Webservices and Queries ** We just upgraded to 7.6.04 SP2 (ARS) and when I run a query in the WUT or MidTier of: 'Start Date and Time' >= "4/23/2012 03:30:00 PM" AND 'Change Status' = "CANCELED" I get records back just fine. When I use SOAP to run this query in our Webservice, everything is fine. But when I try 'Start Date and Time' <= "4/23/2012 03:30:00 PM" AND 'Change Status' = "CANCELED", WUT and Midtier is fine, but I'm getting this error in SOAP: "org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup" Does anyone know why this would error out? Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
