I've actually figured out a way to have a multi-qualified search. The key is
to pass the qualification requirement off to the client side. Basically what
I did was create a single input element called Qualification, then simply
mapped the WS Qualification = (XPATH/ROOT/Qualification). The client side
then passes a string ie ('Status' = "Assigned" OR 'Priority' = "Low" AND
etc). This acts very similiary to the "Advanced Search" functionality in the
User tool.
versicle wrote:
>
> I have set the Qual as follows but still receive the error:
>
> (('Status' = XPATH(/ROOT/Status)) OR (XPATH(/ROOT/Status) = $NULL$)) AND
> (('TSN.IM:HelpDesk-DropDown-Priority' =
> XPATH(/ROOT/TSN.IM_HelpDesk-DropDown-Priority)) OR
> (XPATH(/ROOT/TSN.IM_HelpDesk-DropDown-Priority) = $NULL$))
>
>
>
> Grooms, Frederick W wrote:
>>
>> I don't know if it is generating the error when no results are found,
>> but that is what it looks like it is doing.
>>
>> I think your qualification will need to use OR (excuse my shorthand for
>> Priority):
>>
>> (('Pri' = XPATH(/ROOT/Pri)) OR (XPATH(/ROOT/Pri) = $NULL$))
>> AND
>> (('Status' = XPATH(/ROOT/Status)) OR (XPATH(/ROOT/Status) = $NULL$))
>>
>> Fred
>>
>>
>>
>> -----Original Message-----
>> From: Action Request System discussion list(ARSList)
>> [mailto:[EMAIL PROTECTED] On Behalf Of versicle
>> Sent: Thursday, February 07, 2008 6:12 PM
>> To: [email protected]
>> Subject: Re: Multi-qualified Web Service Search
>>
>> 'TSN.IM:HelpDesk-DropDown-Priority' =
>> XPATH(/ROOT/TSN.IM_HelpDesk-DropDown-Priority) AND 'Status' =
>> XPATH(/ROOT/Status)
>>
>>
>>
>> Grooms, Frederick W wrote:
>>>
>>> And your Web Service Get operation Qualification is?
>>>
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[EMAIL PROTECTED] On Behalf Of versicle
>>> Sent: Thursday, February 07, 2008 5:59 PM
>>> To: [email protected]
>>> Subject: Re: Multi-qualified Web Service Search
>>>
>>> Rick,
>>>
>>> Status is in the input mapping.
>>>
>>> Fred,
>>>
>>> I have set the minOcc to 1 and Nillable to True.
>>>
>>> Here is the WS request I'm sending and the response back:
>>>
>>> Request:
>>>
>>> <soapenv:Envelope
>>> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";
>>> xmlns:urn="urn:HPD_Help_Desk">
>>> <soapenv:Header>
>>> <urn:AuthenticationInfo>
>>> <urn:userName>Demo</urn:userName>
>>> <urn:password></urn:password>
>>> </urn:AuthenticationInfo>
>>> </soapenv:Header>
>>> <soapenv:Body>
>>> <urn:OpGetAllStatus_And_Priority>
>>> <urn:TSN.IM_HelpDesk-DropDown-Priority>Critical -
>>> 1</urn:TSN.IM_HelpDesk-DropDown-Priority>
>>> <urn:Status></urn:Status>
>>> </urn:OpGetAllStatus_And_Priority>
>>> </soapenv:Body>
>>> </soapenv:Envelope>
>>>
>>> Response:
>>>
>>> <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>
>>> <soapenv:Fault>
>>> <faultcode>soapenv:Server.userException</faultcode>
>>> <faultstring>ERROR (4558): Qualification line
>>> error;</faultstring>
>>> <detail>
>>> <ns1:hostname
>>> xmlns:ns1="http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac
>>> .d
>>> ti.terrestar.net</ns1:hostname>
>>> </detail>
>>> </soapenv:Fault>
>>> </soapenv:Body>
>>> </soapenv:Envelope>
>>>
>>> Keep in mind, this operation only has two fields.
>>>
>>> Mike
>>>
>>>
>>> Grooms, Frederick W wrote:
>>>>
>>>> Are these fields defined as Optional (minOccurrs=0) in the Web
>>> Service?
>>>> If you look at the inbound XML you will probably see that (in this
>>>> example) the Status element does not exist.
>>>>
>>>> Try defining these fields a minOccurrs=1 and Nillable. This way the
>>>> portal should always place the element name in the XML even if there
>>>> is no data for that element.
>>>>
>>>> See pg 333 in the "Integrating with Plug-ins and Third-Party
>> Products"
>>>> manual for more info on minOccurrs and Nillable.
>>>>
>>>> Fred
>>>>
>>>> -----Original Message-----
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:[EMAIL PROTECTED] On Behalf Of versicle
>>>> Sent: Thursday, February 07, 2008 5:25 PM
>>>> To: [email protected]
>>>> Subject: Re: Multi-qualified Web Service Search
>>>>
>>>> Yes. Here is the error I'm receiving when passing a NULL value:
>>>>
>>>> ERROR (4558): Qualification line error;
>>>>
>>>> Also here is the Qualification:
>>>> 'Status' = XPATH(/ROOT/Status)
>>>>
>>>>
>>>> Rick Ponzo-2 wrote:
>>>>>
>>>>> When you created the web service did you set the data elements value
>>
>>>>> Nillable = True for each of the fields?
>>>>>
>>>>> Rick Ponzo
>>>>>
>>>>>
>>>>> versicle wrote:
>>>>>> All,
>>>>>>
>>>>>> I have created a WS based on the HelpDesk form and we have a
>>>>>> business
>>>>
>>>>>> requirement from a web Portal to be able to search for tickets
>>>>>> based
>>>
>>>>>> on one or MORE of the following fields, Customer Last Name, Ticket
>>>>>> Number, Company, Status, and Priority. I have created an search
>>>>>> operation and mapped all of the fields above. However, I only
>>>>>> receive
>>>>
>>>>>> responses when each of the fields has a value entered for the
>>>>>> search
>>>
>>>>>> otherwise an error is returned. Is there a way to have a wildcard
>>>>>> in
>>>
>>>>>> the search or a NULL value for one of those fields I dont care
>>>>>> about
>>>
>>>>>> when executing the search?
>>>>>>
>>>>>> I am running ARS 7.1 patch001 and IM 7.0.03 patch006 on Solaris 10.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Mike
>>>>>
>>>>
>>>
>>> ______________________________________________________________________
>>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Multi-qualified-Web-Service-Search-tp15344383p1534
>> 6764.html
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>> ________________________________________________________________________
>> _______
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
>> Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Multi-qualified-Web-Service-Search-tp15344383p15467212.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
