| Author | Message | 
		
		  | adhi | 
			  
				|  Posted: Tue May 10, 2011 5:15 pm    Post subject: Syntax for FILTER NODE IN ESQL |   |  | 
		
		  | Newbie
 
 
 Joined: 10 May 2011Posts: 2
 
 
 | 
			  
				| Hi can anyone help me out with the syntax for FILTER NODE in ESQL 
 Thanks.
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | fjb_saper | 
			  
				|  Posted: Tue May 10, 2011 8:13 pm    Post subject: |   |  | 
		
		  |  Grand High Poobah
 
 
 Joined: 18 Nov 2003Posts: 20767
 Location: LI,NY
 
 | 
			  
				| I believe you can find the answer in the broker infocenter, and in any sample that has a filter node. 
 Have fun
  _________________
 MQ & Broker admin
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | manan.patel | 
			  
				|  Posted: Tue Oct 09, 2012 5:14 am    Post subject: |   |  | 
		
		  | Apprentice
 
 
 Joined: 01 Oct 2012Posts: 25
 
 
 | 
			  
				| there is nothing in that particular location... 
 
 Please post your one little sample here...
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | lancelotlinc | 
			  
				|  Posted: Tue Oct 09, 2012 5:24 am    Post subject: |   |  | 
		
		  |  Jedi Knight
 
 
 Joined: 22 Mar 2010Posts: 4941
 Location: Bloomington, IL USA
 
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | mqjeff | 
			  
				|  Posted: Tue Oct 09, 2012 5:55 am    Post subject: |   |  | 
		
		  | Grand Master
 
 
 Joined: 25 Jun 2008Posts: 17447
 
 
 | 
			  
				| The filter node does not have any different syntax for ESQL than the Compute node does. |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | Esa | 
			  
				|  Posted: Tue Oct 09, 2012 6:47 am    Post subject: |   |  | 
		
		  |  Grand Master
 
 
 Joined: 22 May 2008Posts: 1387
 Location: Finland
 
 | 
			  
				| Except that you will have to refer to Root instead of InputRoot. |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  | NealM | 
			  
				|  Posted: Tue Oct 09, 2012 10:55 am    Post subject: |   |  | 
		
		  |  Master
 
 
 Joined: 22 Feb 2011Posts: 230
 Location: NC or Utah (depends)
 
 | 
			  
				| ...and LocalEnvironment instead of InputLocalEnvironment.... 
 The point of the above (and the above the above) being that you can do a lot of stuff in a Filter Node as in a Compute Node, such as database access/manipulation, global Environment updates....
 BUT, you cannot change anything in Root or LocalEnvironment (any data that the Broker rolls back during failure path processing), just inspect them.
 |  | 
		
		  | Back to top |  | 
		
		  |  | 
		
		  |  |