If you look at the logs on MidTier what does it say the query is?
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sean Garrison
Sent: Tuesday, October 03, 2006 12:35 PM
To: [email protected]
Subject: Re: [Soap Question] Problem with the <= in a query resolved ...
sort of
Thanks Carey for your help. Unfortunately this time it did not resolve
the issue. I'm beginning to think there is either a bug with the soap
interface
(SOAP::Lite) or with web services.
Here is the code change:
if (&soapErrorCheck($response) == 0) {
# add this to get a full array of the results
my @params = $response->paramsout;
# Process each of the records
foreach my $row(@params) {
print($row->{'txt_Service_Event'}." ");
print($row->{'txt_Description'}."\n");
}
}
It still yields 6 results.
I am running this query in Soap:
('dt_Creation Date' >= "09/01/2006 00:00:00 AM") AND ('rad_Severity' =
"1.") AND ('rad_Status' <= "Pending")
It yields 6 results.
Txt_Service_Event rad_Status txt_Description
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
If I run the same query in Remedy:
('dt_Creation Date' >= "09/01/2006 00:00:00 AM") AND ('rad_Severity' =
"1.") AND ('rad_Status' <= "Pending")
I get seven results:
Txt_Service_Event rad_Status txt_Description
1 Pending
2 Pending
3 Re-Opened
4 Pending
5 Re-Opened
6 Pending
7 Pending
I was wondering if anyone else had run into a similar issue???? I am
running ARS 6.3 patch 17 on solaris.
Thanks,
Sean
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Tuesday, October 03, 2006 12:38 PM
To: [email protected]
Subject: Re: [Soap Question] Problem with the <= in a query resolved ...
sort of
Sean,
That looks like Perl, SOAP::Lite to me... :) So forgive me if I have
made a bad assumption...
Reed up on the SOAP::Lite module...
"
IN/OUT, OUT PARAMETERS AND AUTOBINDING
SOAP::Lite gives you access to all parameters (both in/out and out) and
also does some additional work for you. Lets consider following
example:
<mehodResponse>
<res1>name1</res1>
<res2>name2</res2>
<res3>name3</res3>
</mehodResponse>
In that case:
$result = $r->result; # gives you 'name1'
$paramout1 = $r->paramsout; # gives you 'name2', because of
scalar context
$paramout1 = ($r->paramsout)[0]; # gives you 'name2' also
$paramout2 = ($r->paramsout)[1]; # gives you 'name3'
or
@paramsout = $r->paramsout; # gives you ARRAY of out parameters
$paramout1 = $paramsout[0]; # gives you 'res2', same as
($r->paramsout)[0]
$paramout2 = $paramsout[1]; # gives you 'res3', same as
($r->paramsout)[1] "
So I think you should do this...
> if (&soapErrorCheck($response) == 0) {
# add this to get a full array of the results @paramsout =
$response->paramsout;
# Process each of the records
# foreach my $row($response->paramsout()) { # incorrect use of
-->paramsout ?
foreach my $row(@paramsout) {
print($row->{'txt_Service_Event'}." ");
print($row->{'txt_Description'}."\n");
}
}
Maybe there is a more compact syntax than the above, but the above might
also be clearer for the next person too.
HTH.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 10/3/06, Sean Garrison <[EMAIL PROTECTED]> wrote:
> Ok ... the < worked. Thank you so much for your help. Now when I
> actually get the search results the first row is missing ...
>
> For example:
> I am running this query in Soap:
>
> ('dt_Creation Date' >= "09/01/2006 00:00:00 AM") AND ('rad_Severity' =
"1.")
> AND ('rad_Status' <= "Pending")
>
> It yields 6 results.
>
> If I run the same query in Remedy:
>
> ('dt_Creation Date' >= "09/01/2006 00:00:00 AM") AND ('rad_Severity' =
"1.")
> AND ('rad_Status' <= "Pending")
>
> I get 7 results. The first row seems to be missing every time. So I
> have assumed it was my code ...
>
> so here is my soap code that prints out the values:
>
> my $response = $soap->OpGetList($header,$inputData);
>
> #Check for Errors
> if (&soapErrorCheck($response) == 0) { # Process each of the records
> foreach my $row($response->paramsout()) {
> print($row->{'txt_Service_Event'}." ");
> print($row->{'txt_Description'}."\n");
> }
> }
>
>
>
> Am I missing something?
>
> Any input would be greatly appreciated.
>
> Thanks,
>
> Sean
________________________________________________________________________
____
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
