Try this instead
'Category' LIKE XPATH(/ROOT/Tier_1)
and have the webservice pass in the % character.
On Jul 2, 8:32 am, Raido Oja <raido....@gmail.com> wrote:
> I am trying to use LIKE in a web service qualification, querying the
> SRD:ServiceRequestDefintion form. Here is what I have:
>
> 'TakeSRDOfflineFlag' = "Online" AND ('Category1' LIKE
> (XPATH(/ROOT/Tier_1)+"%") OR XPATH(/ROOT/Tier_1) = $NULL$) AND ('Category2'
> LIKE (XPATH(/ROOT/Tier_2)+"%") OR XPATH(/ROOT/Tier_2) = $NULL$) AND
> ('Category3' LIKE (XPATH(/ROOT/Tier_3)+"%") OR XPATH(/ROOT/Tier_3) = $NULL$)
>
> This gives me an error
> ARERR [9130] Error encountered while executing a Web Service :
> ERROR (313): Data types are not appropriate for relational operation;
> ERROR (312): Data types are not appropriate for arithmetic operation;
>
> In a set fields qualification the syntax would work. Can anyone tell what's
> the problem with this qualification? Can I not use LIKE for XPATH elements?
>
> Thank You
>
> Raido
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
