Would the timezone names be the same ones on the Local Tab of the AR System User Preference form?
Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, April 24, 2012 3:42 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries That could probably be it :-) -----Original Message----- From: Kemes, Lisa Sent: Tuesday, April 24, 2012 3:41 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Looks like we are not specifying anything in Local or Timezone. I'll add some data to that and see if it works! 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 3:34 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Ah ... I'm on Linux for the App and Web. In your SOAP AuthenticationInfo are you specifying a timeZone or locale? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 2:29 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Windows XP for the desktop, Windows server 2008 for the app server, Oracle 11g for the backend. 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 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries What platform are you on (as WS does do the DST for me)? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries I think that's the problem. WUT and Midtier does the translation for DST while the webservices do not. Ugh.... That's exactly what we are seeing and now the results make more sense. Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, April 24, 2012 2:16 PM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries Like Fred and Andrew suggested, check your permissions and / or the login used.. I wont be surprised though if there is a difference in the way the WS handles daylight saving time, thus one set of results is slightly different from the other because of the slight difference in an internal translation of the time input as one of the search parameters.. Look at your pliugin logs to look at the xml request that is sent from the client.. Joe -----Original Message----- From: Kemes, Lisa Sent: Tuesday, April 24, 2012 2:07 PM Newsgroups: public.remedy.arsystem.general 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
