I'd try to covert the date/time value as well as selection values into
integers before building the qualifier string. Your query would then
probably look something like this:
'Start Date and Time' <= 1335209400 AND 'Change Status' = 7
Not sure if this will help but might be worth a try.
Thilo Stapff
ApproLogic GmbH
Hanauer Landstr. 189
60314 Frankfurt am Main
Phone: +49 69 9043 5820
Fax: +49 69 9043 5821
EMail: thilo.sta...@apprologic.de
http://www.apprologic.com
On 25.04.2012 17:31, Kemes, Lisa wrote:
I added "GMT-5:00 (EST) America/New_York" to the timeZone and it's still coming
back with invalid data. ARRGH! Does anyone else experiencing this?
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 4:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries
In the AuthenticationInfo structure for ARS webservices there are 5 elements.
User and Password are required. The other 3 (authentication, locale, and
timeZone) are not required.
Fred
-----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:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries
I am fairly new to consuming web services too, and am at the moment working on
OIM web service integration as well..
Isn't there a locale input that the WS requires? I would think that's where it
will pick it from..
Joe
-----Original Message-----
From: Kemes, Lisa
Sent: Tuesday, April 24, 2012 3:55 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Webservices and Queries
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
