ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to Set TOPIC Base condition in Filter node Using XMLNS

Post new topic  Reply to topic
 How to Set TOPIC Base condition in Filter node Using XMLNS « View previous topic :: View next topic » 
Author Message
raghug
PostPosted: Mon Jun 11, 2007 1:09 pm    Post subject: How to Set TOPIC Base condition in Filter node Using XMLNS Reply with quote

Acolyte

Joined: 19 Jul 2006
Posts: 60
Location: NJ
Hi All
I Hanve a problem with XMLNS
How to Set TOPIC Base condition in Filter node Using XMLNS see below My Message Input
<?xml version="N.0" ?>
<g%EventTransaction>
<mmtopics:ContentManagerEventSubscriptionTopics
xmlns:mmtopics="http://vNx0.mmtopics.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.mmtopics.contentmanager.ts.mynet.net/ ContentManagerEventSubscriptionTopicsVN.0.xsd">
<mmtopics:TopicName>/g%/Application/XML/IC/piC_CommLoan/#0N</mmtopics:TopicName>
</mmtopics:ContentManagerEventSubscriptionTopics> <rpieheader:ContentManagerItemEventHeader
xmlns:rpieheader="http://vNx0.rpieheader.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.rpieheader.contentmanager.ts.mynet.net/ ContentManagerItemEventHeaderVN.0.xsd">
<rpieheader:EventCode>#0N </rpieheader:EventCode>
<rpieheader:EventDescription> </rpieheader:EventDescription>
<rpieheader:EventTimeStamp>@007-0%-0*</rpieheader:EventTimeStamp>
<rpieheader:EventUserID>D0060@</rpieheader:EventUserID>
<rpieheader:ItemId> AN00N00NA07E0@B%04@@C469#6</rpieheader:ItemId>
<rpieheader:ApplicationId>IC</rpieheader:ApplicationId>
<rpieheader:SectionCloseN>
</rpieheader:SectionCloseN>
</rpieheader:ContentManagerItemEventHeader>
<cmitemdata:ContentManagerItemData
xmlns:cmitemdata="http://vNx0.cmitemdata.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.cmitemdata.contentmanager.ts.mynet.net/
ContentManagerApplicationMetadataVN.0.xsd">
<piC_CommLoan Xdddd="00%" DocTypeCD="SPA" DocumentStatus="Active" Obligation="0000000%%%" Obligor="00000000%%">
<piC_CLSWorkflow BundleID="NNNNNNNNNN" CriticalDocInd="**********" DealID="##########" FacilityID="%%%%%%%%%%" FacilityNumber="6666666666"
GroupID="@@@@@@@@@@" OCRLine="9999999999" ProcessingSite="44444444444" RequestID="00000000000" WorkType="77777777777"/>
<piC_CLSDSRInfo Cap_Rsrch_Data="asdfghjkl" EndImageAddress="N@#4%P7*90N4" ImageAddress="N@#4%P7*90N@"/>
<piC_CLSNoteInfo NoteDate="@007-0%-0@"/>
<piC_CLSDOTInfo Book="00N " Page="00@ "/>
<piC_CLSGuarInfo Guarantor="9999999999" Obligation="0000000%%%"/>
<piC_CLSUCCInfo FilingNumber="%%%%%%%%%%"/>
<piC_CLSTitlInfo VINNumber="09*76%4#@N"/>
<ICMBASE/>
</piC_CommLoan>
</cmitemdata:ContentManagerItemData> </g%Event>

My ESQL IN FILTER NODE

DECLARE mmtopics NAMESPACE 'http://v1x0.mmtopics.contentmanager.ts.wachovia.net';
DECLARE mmieheader NAMESPACE 'http://v1x0.mmieheader.contentmanager.ts.mynet.net/';
DECLARE mmitemdata NAMESPACE 'http://v1x0.mmitemdata.contentmanager.ts.mynet.net/';
IF Root.XMLNS.g3EventTransaction.ContentManagerEventSubscriptionTopics.TopicName IS NULL THEN


But The Above Line Shows Wrong PleaseI think so . Give me ESQL or Share me an Idea

Thanks
WIN
Back to top
View user's profile Send private message Yahoo Messenger
jefflowrey
PostPosted: Mon Jun 11, 2007 1:12 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
You need to qualify the appropriate elements in your ESQL path with the appropriate namespace prefixes.

You need to consider the difference between a missing element and an empty element.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
raghug
PostPosted: Tue Jun 12, 2007 4:42 am    Post subject: Re: How to Set TOPIC Base condition in Filter node Using XML Reply with quote

Acolyte

Joined: 19 Jul 2006
Posts: 60
Location: NJ
How to Set TOPIC Base condition in Filter node Using XMLNS

MESPACE 'http://v1x0.mmieheader.contentmanager.ts.mynet.net/';
DECLARE mmitemdata NAMESPACE 'http://v1x0.mmitemdata.contentmanager.ts.mynet.net/';
IF Root.XMLNS.g3EventTransaction.ContentManagerEventSubscriptionTopics.TopicName IS NULL THEN


But The Above Line Shows Wrong PleaseI think so . Give me ESQL or Share me an Idea

Thanks
WIN[/quote]
Back to top
View user's profile Send private message Yahoo Messenger
jefflowrey
PostPosted: Tue Jun 12, 2007 4:44 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
You declared the prefix.

You didn't use it.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
raghug
PostPosted: Tue Jun 12, 2007 4:49 am    Post subject: Re: How to Set TOPIC Base condition in Filter node Using XML Reply with quote

Acolyte

Joined: 19 Jul 2006
Posts: 60
Location: NJ
raghug wrote:
Hi All
I Hanve a problem with XMLNS
How to Set TOPIC Base condition in Filter node Using XMLNS see below My Message Input
<?xml version="N.0" ?>
<g%EventTransaction>
<mmtopics:ContentManagerEventSubscriptionTopics
xmlns:mmtopics="http://vNx0.mmtopics.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.mmtopics.contentmanager.ts.mynet.net/ ContentManagerEventSubscriptionTopicsVN.0.xsd">
<mmtopics:TopicName>/g%/Application/XML/IC/piC_CommLoan/#0N</mmtopics:TopicName>
</mmtopics:ContentManagerEventSubscriptionTopics> <rpieheader:ContentManagerItemEventHeader
xmlns:rpieheader="http://vNx0.rpieheader.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.rpieheader.contentmanager.ts.mynet.net/ ContentManagerItemEventHeaderVN.0.xsd">
<rpieheader:EventCode>#0N </rpieheader:EventCode>
<rpieheader:EventDescription> </rpieheader:EventDescription>
<rpieheader:EventTimeStamp>@007-0%-0*</rpieheader:EventTimeStamp>
<rpieheader:EventUserID>D0060@</rpieheader:EventUserID>
<rpieheader:ItemId> AN00N00NA07E0@B%04@@C469#6</rpieheader:ItemId>
<rpieheader:ApplicationId>IC</rpieheader:ApplicationId>
<rpieheader:SectionCloseN>
</rpieheader:SectionCloseN>
</rpieheader:ContentManagerItemEventHeader>
<cmitemdata:ContentManagerItemData
xmlns:cmitemdata="http://vNx0.cmitemdata.contentmanager.ts.mynet.net/"
xmlns:xsi="http://www.w#.org/@00N/XMLSchema-instance"
xsi:schemaLocation="http://vNx0.cmitemdata.contentmanager.ts.mynet.net/
ContentManagerApplicationMetadataVN.0.xsd">
<piC_CommLoan Xdddd="00%" DocTypeCD="SPA" DocumentStatus="Active" Obligation="0000000%%%" Obligor="00000000%%">
<piC_CLSWorkflow BundleID="NNNNNNNNNN" CriticalDocInd="**********" DealID="##########" FacilityID="%%%%%%%%%%" FacilityNumber="6666666666"
GroupID="@@@@@@@@@@" OCRLine="9999999999" ProcessingSite="44444444444" RequestID="00000000000" WorkType="77777777777"/>
<piC_CLSDSRInfo Cap_Rsrch_Data="asdfghjkl" EndImageAddress="N@#4%P7*90N4" ImageAddress="N@#4%P7*90N@"/>
<piC_CLSNoteInfo NoteDate="@007-0%-0@"/>
<piC_CLSDOTInfo Book="00N " Page="00@ "/>
<piC_CLSGuarInfo Guarantor="9999999999" Obligation="0000000%%%"/>
<piC_CLSUCCInfo FilingNumber="%%%%%%%%%%"/>
<piC_CLSTitlInfo VINNumber="09*76%4#@N"/>
<ICMBASE/>
</piC_CommLoan>
</cmitemdata:ContentManagerItemData> </g%Event>

My ESQL IN FILTER NODE

DECLARE mmtopics NAMESPACE 'http://v1x0.mmtopics.contentmanager.ts.mynet.net';
DECLARE mmieheader NAMESPACE 'http://v1x0.mmieheader.contentmanager.ts.mynet.net/';
DECLARE mmitemdata NAMESPACE 'http://v1x0.mmitemdata.contentmanager.ts.mynet.net/';
IF Root.XMLNS.g3EventTransaction.ContentManagerEventSubscriptionTopics.TopicName IS NULL THEN


But The Above Line Shows Wrong PleaseI think so . Give me ESQL or Share me an Idea

Thanks
WIN
Back to top
View user's profile Send private message Yahoo Messenger
jefflowrey
PostPosted: Tue Jun 12, 2007 4:51 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Please read what I've said.

Please think about it.

I will, one final time, be clear about exactly where the problem is. Everything else is up to you to learn and try and think and fix.

This line of code
Code:

IF Root.XMLNS.g3EventTransaction.ContentManagerEventSubscriptionTopics.TopicName IS NULL THEN


does not use the namespace prefixes that you have previously declared.

So your ESQL path does not match the message tree, and so you aren't getting the vlaue that you think you are.

This is a basic use of ESQL, and should have been covered in your training.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Vijji
PostPosted: Tue Jun 12, 2007 8:04 am    Post subject: Reply with quote

Voyager

Joined: 30 Aug 2005
Posts: 83
Hi raghug,

Try the below IF statement instead of ur IF
Code:

   IF Root.XMLNS.g3EventTransaction.mmtopics:ContentManagerEventSubscriptionTopics.mmtopics:TopicName IS NULL THEN


I think it will work

Cheers,
Vijji.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to Set TOPIC Base condition in Filter node Using XMLNS
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.