Skip to main content
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Barney Boisvert
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Barney Boisvert ( @barneyb )

Ask Ben: Selecting XML Nodes That Have A Given Parent Node Using XPath

Published in , Comments (1)

Let's say I have an XML file with the following data in it: [private information]. Right now, the way the component parses the XML file, it returns all instances of DUNS it finds. Is there any way to limit the tag that is searches through and only return say the DUNS from the BasicInfo parent tag? If so, can you provide an example on how that might be done? Thanks again!

When you search for nodes in a given XML document by name (ex. //name), it will return nodes anywhere in that XML document with the matching name. This is what you are experiencing. If you want to return only nodes within a given parent node, then you just have to be a little bit more specific in you XPath. There are two ways to do this:

  1. Specify the parent node in the node path.

  2. Specify the parent node in the target node predicate.

Before we get into those two options, let's first build ourselves a test ColdFusion XML document:

<!--- Generate ColdFusion XML document. --->
<cfxml variable="xmlData">

		<name>Bodybuilding Books</name>

				<name>Muscle: Confessions Of An Unlikely Bodybuilder</name>
				<author>Samuel Wilson Fussell</author>
				<name>Gorilla Suit: My Adventures In Bodybuilding</name>
				<author>Bob Paris</author>


In this demo XML document, you can see that we have three "name" nodes: one for the Category and one for each Book node. Like you have experienced, if we searched for:

<!--- Query for all names. --->
<cfset arrNameNodes = XmlSearch(
	) />

<!--- Output resultant node set. --->

... we'd get back all three:

XPath That Found Any Name Node Within The Given XML Document.

But, if we want to only get back the Name nodes contained within the Book nodes, we have to use one of the two XPath options above. We can specify the parent node in the node search path:

	Query for all name nodes that are contained within a
	book node.
<cfset arrNameNodes = XmlSearch(
	) />

This will search for Name nodes that are contained within book nodes:

XPath That Found Name Nodes Contained Within Book Nodes Within The Given XML Document.

We can also search for all Name nodes and then specify in the predicate that it must have a Book parent node:

	Query for all name nodes that are children of
	the parent node: book.
<cfset arrNameNodes = XmlSearch(
	"//name[ parent::book ]"
	) />

This will search for all Name nodes and then filter the node set based on the parent node of the given node. Running the above code gives us the same node set as above.

Either of these methods will return only the two Name nodes contained within the Book nodes. The former, however, is probably faster as you limit your search earlier on in the XPath; but, I have not done any performance testing on this.

Want to use code from this post? Check out the license.

Reader Comments


Somewhat related question, once you find a node, is there a way to determine the parent?

In your books example, let's modify the xml to include an id attribute in the book tag. Once I find all the name nodes, I want to find the parent and if the parent is "book", then get the id.

I know I could just search for all book nodes, but my real case I want to find all name nodes, book or otherwise, and then do different business logic based on the parent and other factors.

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel