Using XPath To Select A Node That Does Not Contain Another Node In ColdFusion

Posted March 25, 2010 at 10:09 AM by Ben Nadel

Tags: ColdFusion

Just a quick post on XPath in ColdFusion. This morning, when I was writing about screen-scraping movie showtimes off Fandango.com, I had to use an XPath query that looked for an XML node that did not contain another XML node. In the past, I've blogged about gathering nodes that did not contain a text node (or a given text value); but, I don't think I have ever talked about getting nodes that did not contain a given element node. As such, I wanted to throw together a very brief example of how this is done.

To quickly recap, XPath queries can contain predicates. These are qualitative queries, wrapped in brackets, that filter the given node into or out of the resultant node-set. For example, in the given XPath query:

//a[ @rel = 'home' ]

... we are looking for an "a" element node that has an href attribute that contains the value "home." The predicate, in this case, is the relative query, "[ @rel = 'home' ]". A predicate can contain just about anything so long as that can be boiled down to a truthy / falsey value.

If we want to search for a node that does not contain another node, we can use a negated XPath predicate. Populated node sets are truthy values. As such, if we want to find a node that does not contain a given node, we need to negate the predicate in which the node does contain the given node. In XPath, this negation can be performed by the not() function.

To see this in action, I am going to select from a collection a movies all movies that are not musicals:

  • <!--- Create the XML document. --->
  • <cfxml variable="movies">
  •  
  • <movies>
  • <movie>
  • <name>Terminator</name>
  • <genre>
  • <action />
  • <adventure />
  • </genre>
  • </movie>
  • <movie>
  • <name>De-Lovely</name>
  • <genre>
  • <musical />
  • </genre>
  • </movie>
  • <movie>
  • <name>Sex Drive</name>
  • <genre>
  • <comedy />
  • </genre>
  • </movie>
  • </movies>
  •  
  • </cfxml>
  •  
  •  
  • <!--- Query for all movies that are not musicals. --->
  • <cfset nonMusicals = xmlSearch(
  • movies,
  • "//movie[ not( genre/musical ) ]"
  • ) />
  •  
  • <!--- Output the selected movies. --->
  • <cfdump
  • var="#nonMusicals#"
  • label="Non-musical Movies."
  • />

As you can see, our XPath query is using the following search:

//movie[ not( genre/musical ) ]

Within each movie node, we are checking to see if the node contains the ancestor genre, "musical". Of course, since those are the movies that we specifically do not want to select, we then use the not() function to turn any matching musical node set from a truthy value into a false boolean value. This false then filters the given movie out of the resultant node set, returning only movies that do not contain the musical element node.

When we run the above code, we get the following CFDump output:

 
 
 
 
 
 
Selecing An XML Node With XPath That Does Not Contain Another Given Node. 
 
 
 

As you can see, De-Lovely, a musical, was not returned in the resultant node set. This is a minor, but powerful feature of XPath.




Reader Comments

Mar 25, 2010 at 7:38 PM // reply »
67 Comments

It's good to see there's always something new I can learn about XPath. Good post. Cheers.

--
Adam


Mar 26, 2010 at 7:57 AM // reply »
11,246 Comments

@Adam,

No problem my man. XPath is some cool stuff.


Nov 3, 2012 at 1:27 AM // reply »
1 Comments

hi,
This is the one which help me allot . i am very thankful.


Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 24, 2013 at 5:39 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Adam Oops! My mistake! I hadn't gotten that far in my testing - I'm still baby stepping my way through the process. ... read »
May 24, 2013 at 5:13 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
Hi Jason, Thanks for checking up on that, but I still stand firm on my position. :) There are actually two listLast()'s in use, and you're right that the one using a space as a delimiter is fine. ... read »
May 24, 2013 at 4:45 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Ben I have been lurking your site for quite some time, and haven't stepped up to comment until today. Thanks for all the great info - keep it up! @Adam I believe you are mistaken... as the commen ... read »
May 24, 2013 at 11:21 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@WebManWalking, Ha ha, let's us never speak of justifying "##" notation again :P ... read »
May 24, 2013 at 11:18 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, Ah, so it was indeed how I vaguely remembered it to be: A direct assignment value = users.id[ i ] causes value to retain the sticky datatype of the query column. Although unnecessary in ... read »
May 24, 2013 at 9:11 AM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Brandon, Hi, No, I haven't been able to do that. I have just kept it as it is. ... read »
May 23, 2013 at 9:52 PM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Muhmmadibn Did you figure out a solution to launching PDFs? I am running into the same issues myself. There is no way to close the PDF or go back once you launch it. Thanks in advance! ... read »
May 23, 2013 at 6:06 PM
The Girl Who Broke My Heart, And Made Me A Better Person
Good day,ladies and gentle men, my name is Dr AMADI the great spell caster in Africa, i have help so many people for different kind of problems,who say there is no solution to problems on earth, that ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools