I have an xml file named Trees.xml.
now the xml file is as below
<////////xml///////>
<report xmlns="http://developer.cogno s.com/schemas/impromptu/report/1.0/" timeStamp="4652 E450" schemaVersion=" 1.0" fileFormat="3E7 A">
+<header>
+<layoutSpec>
-<queries>
-<query isTemplate="no" type="power">
<name/>
+<columns>
- <filters>
- <detail>
- <expression>
<name>New Expression</name>
<type>detail_fi lter</type>
<dataType>boole an</dataType>
ColumnRef["GOS"."PRODUCT_ MULTILINGUAL"." PRODUCT_NAME"] starts with "I"
</expression>
</detail>
</filters>
<////////////xml////////////>
I have loaded the file into an object xml_document as declared below.
</////////code/////////////>
Dim xml_document As DOMDocument30
Set xml_document = New DOMDocument30
xml_document.Lo ad App.path & "Trees.xml"
How can i access the filter expression(Colu mnRef["GOS"."PRODUCT_ MULTILINGUAL"." PRODUCT_NAME"] starts with "I" ) using the object xml_document. I gave it as
<************** *************** *******>
Set getFilterNode = xml_document.se lectNodes("/report/queries/query/filter/detail/expression")
MsgBox "filter" & getFilterNode.I tem(0).Text
<************** *************** *******>
but nothing is getting displayed
now the xml file is as below
<////////xml///////>
<report xmlns="http://developer.cogno s.com/schemas/impromptu/report/1.0/" timeStamp="4652 E450" schemaVersion=" 1.0" fileFormat="3E7 A">
+<header>
+<layoutSpec>
-<queries>
-<query isTemplate="no" type="power">
<name/>
+<columns>
- <filters>
- <detail>
- <expression>
<name>New Expression</name>
<type>detail_fi lter</type>
<dataType>boole an</dataType>
ColumnRef["GOS"."PRODUCT_ MULTILINGUAL"." PRODUCT_NAME"] starts with "I"
</expression>
</detail>
</filters>
<////////////xml////////////>
I have loaded the file into an object xml_document as declared below.
</////////code/////////////>
Dim xml_document As DOMDocument30
Set xml_document = New DOMDocument30
xml_document.Lo ad App.path & "Trees.xml"
How can i access the filter expression(Colu mnRef["GOS"."PRODUCT_ MULTILINGUAL"." PRODUCT_NAME"] starts with "I" ) using the object xml_document. I gave it as
<************** *************** *******>
Set getFilterNode = xml_document.se lectNodes("/report/queries/query/filter/detail/expression")
MsgBox "filter" & getFilterNode.I tem(0).Text
<************** *************** *******>
but nothing is getting displayed
Comment