Re: Multi-qualified Web Service Search
Hello, When you are doing a operation of type Get in webservice, then the qualification plays major role. For the qualification to work you should map those fields used in qualification in Input mapping. i.e. in your case u r using dynamic qualification based on 'Status','Priority' etc. So u must map those fields Input mapping. Hope this will help you... Thanks n Regards, 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 > -- View this message in context: http://www.nabble.com/Multi-qualified-Web-Service-Search-tp15344383p15474535.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"
Re: Multi-qualified Web Service Search
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: arslist@ARSLIST.ORG >> 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: arslist@ARSLIST.ORG >>> 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: >>> >>> >> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >>> xmlns:urn="urn:HPD_Help_Desk"> >>> >>> >>> Demo >>> >>> >>> >>> >>> >>> Critical - >>> 1 >>> >>> >>> >>> >>> >>> Response: >>> >>> >> 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:Server.userException >>> ERROR (4558): Qualification line >>> error; >>> >>> >> xmlns:ns1="http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac >>> .d >>> ti.terrestar.net >>> >>> >>> >>> >>> >>> 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 O
Re: Multi-qualified Web Service Search
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: arslist@ARSLIST.ORG > 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: arslist@ARSLIST.ORG >> 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: >> >> > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; >> xmlns:urn="urn:HPD_Help_Desk"> >> >> >> Demo >> >> >> >> >> >> Critical - >> 1 >> >> >> >> >> >> Response: >> >> > 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:Server.userException >> ERROR (4558): Qualification line >> error; >> >> > xmlns:ns1="http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac >> .d >> ti.terrestar.net >> >> >> >> >> >> 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: arslist@ARSLIST.ORG >>> 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 ti
Re: Multi-qualified Web Service Search
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG > 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: > > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; > xmlns:urn="urn:HPD_Help_Desk"> > > > Demo > > > > > > Critical - > 1 > > > > > > Response: > > 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:Server.userException > ERROR (4558): Qualification line > error; > > xmlns:ns1="http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac > .d > ti.terrestar.net > > > > > > 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: arslist@ARSLIST.ORG >> 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"
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: arslist@ARSLIST.ORG > 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: > > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; > xmlns:urn="urn:HPD_Help_Desk"> > > > Demo > > > > > > Critical - > 1 > > > > > > Response: > > 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:Server.userException > ERROR (4558): Qualification line > error; > > xmlns:ns1="http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac.d > ti.terrestar.net > > > > > > 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: arslist@ARSLIST.ORG >> 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-tp15344383p15346764.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"
Re: Multi-qualified Web Service Search
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: arslist@ARSLIST.ORG 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: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:urn="urn:HPD_Help_Desk"> Demo Critical - 1 Response: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> soapenv:Server.userException ERROR (4558): Qualification line error; http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac.d ti.terrestar.net 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: arslist@ARSLIST.ORG > 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"
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: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:urn="urn:HPD_Help_Desk"> Demo Critical - 1 Response: http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> soapenv:Server.userException ERROR (4558): Qualification line error; http://xml.apache.org/axis/";>ITSSTX3D3BMCWEB01.dev.rel3.tac.dti.terrestar.net 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: arslist@ARSLIST.ORG > 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-tp15344383p15346604.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"
Re: Multi-qualified Web Service Search
Is Status the name of the element on the input mapping? If not, it should be. Rick Ponzo versicle wrote: 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Multi-qualified Web Service Search
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: arslist@ARSLIST.ORG 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"
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-tp15344383p15346109.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"
Re: Multi-qualified Web Service Search
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"
Multi-qualified Web Service Search
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 -- View this message in context: http://www.nabble.com/Multi-qualified-Web-Service-Search-tp15344383p15344383.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"