Does Biztalk 2006 support Xpath 2.0 ??? and function like matches.... ???

[philippe...@gmail.com]

hello,

i have a strange issue that i dont understand... i have the following
XPath inside a Expression shape :

xmlFilteredNodeList = xpath(msgSIGA_XML_Incomming, @"/*[local-
name()='ENTETE' and namespace-uri()='ITF_COMPTABLES_SIGA.xsd']/*[local-
name()='DONNEES']/*[local-name()='VENTE']");

that works perfectly well and return me a node list... now i want to
make it a bit more complicat... i want to filter it whit my rex
expres, so the call will looks like that :

xmlFilteredNodeList = xpath(msgSIGA_XML_Incomming, @"/*[local-
name()='ENTETE' and namespace-uri()='ITF_COMPTABLES_SIGA.xsd']/*[local-
name()='DONNEES']/*[local-name()='VENTE']
[matches(LIB_CODE_COMPTA_CEB,'..TV....A\d\d\d\d\d')]");

And i got this runtime error :

Namespace Manager or XsltContext needed. This query has a prefix,
variable, or user-defined function. Stack : at
MS.Internal.Xml.XPath.CompiledXpathExpr.get_QueryTree()
at System.Xml.XPath.XPathNavigator.Evaluate(XPathExpression expr,
XPathNodeIterator context)
at System.Xml.XPath.XPathNavigator.Evaluate(String xpath)
at Microsoft.XLANGs.Core.Part.XPathLoad(Part sourcePart, String
xpath, Type dstType)
at VP.TVP_VP_SIGA.BT.ORC.orcSIGA.segment3(StopConditions stopOn)
at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s,
StopConditions stopCond, Exception& exp) Source System.Xml

but that Xpath works perfectly well in XMLSpy... i dont understand why
it doesnt in Biztalk 2006....!!!! plz any help will be gratly
appreciated....

XML IM using :

<ENTETE NOM_INTERFACE="COMPTA" VERSION_INTERFACE="01"
DATE_FABRICATION="2007-10-05" NUM_EXPLOITANT="32" NUM_SEQUENCE="00015"
xmlns="ITF_COMPTABLES_SIGA.xsd">
<DONNEES>
<VENTE>
<NUM_EXPLOITANT>32</NUM_EXPLOITANT>
<DATE_VENTE>2007-10-01</DATE_VENTE>
<CODE_COMPTA_CEB>CS3201</CODE_COMPTA_CEB>
<LIB_CODE_COMPTA_CEB>32TVXPORA00001PH-01-CS</LIB_CODE_COMPTA_CEB>
<CODE_CPT_AGENT>CS3204</CODE_CPT_AGENT>
<LIB_CODE_CPT_AGENT>32CSLCR-FIXE-620002-CS</LIB_CODE_CPT_AGENT>
<NUM_RESEAU>2</NUM_RESEAU>
<CODE_PRODUIT>T6-RP</CODE_PRODUIT>
<CODE_ARTICLE>TCKR20071</CODE_ARTICLE>
<DDV_ARTICLE>1997-01-01</DDV_ARTICLE>
<DFV_ARTICLE>1997-01-01</DFV_ARTICLE>
<MODE_PAIEMENT>0</MODE_PAIEMENT>
<NOMBRE>1</NOMBRE>
<MONTANT>600</MONTANT>
</VENTE>
<VENTE>
<NUM_EXPLOITANT>32</NUM_EXPLOITANT>
<DATE_VENTE>2007-10-01</DATE_VENTE>
<CODE_COMPTA_CEB>CS3201</CODE_COMPTA_CEB>
<LIB_CODE_COMPTA_CEB>32TVXPORA00002PH-01-CS</LIB_CODE_COMPTA_CEB>
<CODE_CPT_AGENT>CS3204</CODE_CPT_AGENT>
<LIB_CODE_CPT_AGENT>32CSLCR-FIXE-620002-CS</LIB_CODE_CPT_AGENT>
<NUM_RESEAU>2</NUM_RESEAU>
<CODE_PRODUIT>T6-RP</CODE_PRODUIT>
<CODE_ARTICLE>TCKR20071</CODE_ARTICLE>
<DDV_ARTICLE>1997-01-01</DDV_ARTICLE>
<DFV_ARTICLE>1997-01-01</DFV_ARTICLE>
<MODE_PAIEMENT>0</MODE_PAIEMENT>
<NOMBRE>1</NOMBRE>
<MONTANT>600</MONTANT>
</VENTE>
<VENTE>
<NUM_EXPLOITANT>32</NUM_EXPLOITANT>
<DATE_VENTE>2007-10-01</DATE_VENTE>
<CODE_COMPTA_CEB>CS3201</CODE_COMPTA_CEB>
<LIB_CODE_COMPTA_CEB>32TVXPORT00003PH-01-CS</LIB_CODE_COMPTA_CEB>
<CODE_CPT_AGENT>CS3204</CODE_CPT_AGENT>
<LIB_CODE_CPT_AGENT>32CSLCR-FIXE-620002-CS</LIB_CODE_CPT_AGENT>
<NUM_RESEAU>2</NUM_RESEAU>
<CODE_PRODUIT>T6-RP</CODE_PRODUIT>
<CODE_ARTICLE>TCKR20071</CODE_ARTICLE>
<DDV_ARTICLE>1997-01-01</DDV_ARTICLE>
<DFV_ARTICLE>1997-01-01</DFV_ARTICLE>
<MODE_PAIEMENT>0</MODE_PAIEMENT>
<NOMBRE>1</NOMBRE>
<MONTANT>600</MONTANT>
</VENTE>
</DONNEES>
<SIGNATURE TYPE_ALGO="1">719FC155944878C59D818DB289EA9CF0</SIGNATURE>
</ENTETE>

[ThomasSløkTvedt]

I believe it is because XPath 2.0 is not supported.. :( You are probably trying to use a XPath 2.0 function (maybe local-name()?), and then you get an error that the function does not exist, please supply a namespace where I can find this unknown function..

philippe.kozube wrote:

Does Biztalk 2006 support Xpath 2.0 ??? and function like matches.... ???
14-Nov-07

hello,

XML IM using :

EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorials/aspnet/8a2ea78b-f1e3-45b4-93ef-32b2d802ae17/wpf-datagrid-custom-pagin.aspx