I thing my problem is that the attribute is on a couple of nodes down from the node that I need to select. Also, I need to pull values from different levels. Not sure how to construct the XPath.
<?xml version="1.0"?>
<software_inventory>
<software xmlns:xsi="Software.xsd">
<title>Adobe Photoshop</title>
<vendor>Adobe</vendor>
<category>Graphics</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
<platform>Linux</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 2GB Hard Drive" Software_Requiremnts="32/64 bit" Price="399">CS 5.5</Version>
</Approved_Versions>
</software>
<software>
<title>Winzip</title>
<vendor>Winzip International</vendor>
<category>Utility</category>
<support_platforms>
<platform>Windows Vista</platform>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="2GB Ram 250MB Hard Drive" Software_Requiremnts="32/64 bit" Price="29.99">19</Version>
</Approved_Versions>
</software>
<software>
<title>Office 365</title>
<vendor>Microsoft</vendor>
<category>Productivity</category>
<support_platforms>
<platform>Windows Vista</platform>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 2GB Hard Drive" Software_Requiremnts="32/64 bit" Price="99">Office 365</Version>
</Approved_Versions>
</software>
<software>
<title>Visual Studio</title>
<vendor>Microsoft</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 2GB Hard Drive" Software_Requiremnts="32/64 bit" Price="1199">2013</Version>
</Approved_Versions>
</software>
<software>
<title>Google Chrome</title>
<vendor>Google</vendor>
<category>Productivity</category>
<support_platforms>
<platforms>Windows Vista</platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="1GB Ram 250MB Hard Drive" Software_Requiremnts="32/64 bit" Price="0">23</Version>
</Approved_Versions>
</software>
<software>
<title>Microsoft SQL Server 2012</title>
<vendor>Microsoft</vendor>
<category>DBMS</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
<platform>Windows Server 2012</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 4GB Hard Drive" Software_Requiremnts="64 bit" Price="3990">2012</Version>
</Approved_Versions>
</software>
<software>
<title>Microsoft Paint</title>
<vendor>Microsoft</vendor>
<category>Graphics</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
<platform>Linux</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="16GB Ram 1TB Hard Drive" Software_Requiremnts="32/64 bit" Price="1000000">22</Version>
</Approved_Versions>
</software>
<software>
<title>Notepad</title>
<vendor>Microsoft</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="32GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="500000">3</Version>
</Approved_Versions>
</software>
<software>
<title>Oracle Database</title>
<vendor>Oracle</vendor>
<category>DBMS</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
<platform>Windows Server 2012</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="8GB Ram 4GB Hard Drive" Software_Requiremnts="64 bit" Price="4000">Enterprise Edition</Version>
<Version Hardware_Requirements="8GB Ram 3GB Hard Drive" Software_Requiremnts="64 bit" Price="3000">Standard Edition</Version>
</Approved_Versions>
</software>
<software>
<title>Adobe Dreamweaver</title>
<vendor>Adobe</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="2GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="299">CS5</Version>
</Approved_Versions>
</software>
<software>
<title>Adobe Fireworks</title>
<vendor>Adobe</vendor>
<category>Graphics</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="2GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="1">CS5</Version>
</Approved_Versions>
</software>
<software>
<title>Adobe Flash</title>
<vendor>Adobe</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 1GB Hard Drive" Software_Requiremnts="32/64 bit" Price="499">CS5</Version>
</Approved_Versions>
</software>
<software>
<title>Adobe Illustrator</title>
<vendor>Adobe</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="499">CS5</Version>
</Approved_Versions>
</software>
<software>
<title>Google Earth Pro</title>
<vendor>Google</vendor>
<category>Productivity</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="999">14</Version>
</Approved_Versions>
</software>
<software>
<title>Eclipse</title>
<vendor>The Eclipse Foundation</vendor>
<category>Development</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="4GB Ram 500MB Hard Drive" Software_Requiremnts="32/64 bit" Price="0">12</Version>
</Approved_Versions>
</software>
<software>
<title>Candy Crush Saga</title>
<vendor>King.com ltd.</vendor>
<category>Productivity</category>
<support_platforms>
<platform>Windows 7</platform>
<platform>Windows 8</platform>
<platform>Windows 8.1</platform>
</support_platforms>
<Approved_Versions>
<Version Hardware_Requirements="32GB Ram 500GB Hard Drive" Software_Requiremnts="32/64 bit" Price="2000000">99</Version>
</Approved_Versions>
</software>
</software_inventory>
I need to select all graphics software (category) that runs on linux (platform) and I need the minimum, maximum, and average price (version/@price). This seems very complex to me, and I really need some help.
Thanks,
David
No comments:
Post a Comment