XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Cynthia van BovenSubject: Xquery filter on multiple values
Author: Cynthia van Boven
Date: 26 Jun 2009 07:44 AM
Dear Stylussees,

I want to filter an xml file on multiple values but I don't know what the query syntax is for 'where <column_name> in (x,y,z)' so I am now using a very long query when testing on a lot of values:

for $Request in /eExact/Requests/Request where $Request/FreeFields/FreeNumbers/FreeNumber='1513'or $Request/FreeFields/FreeNumbers/FreeNumber='1589'or $Request/FreeFields/FreeNumbers/FreeNumber='2710'or $Request/FreeFields/FreeNumbers/FreeNumber='2813'or $Request/FreeFields/FreeNumbers/FreeNumber='3459'or $Request/FreeFields/FreeNumbers/FreeNumber='3638'or ........

There must be a simple answer to this question.....



Alberto MassariSubject: Xquery filter on multiple values
Author: Alberto Massari
Date: 26 Jun 2009 08:36 AM
Hi Cynthia,
in XPath the operator '=' returns true is at least one combination of the items in the left and right node sets is equal.
So you can write

for $Request in /eExact/Requests/Request
where $Request/FreeFields/FreeNumbers/FreeNumber = ('1513','1589','2710','2813','3459','3638',...)
return ...


Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.