XmlDataSource XPath question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jones
    #1

    XmlDataSource XPath question

    Hello,

    I'm trying to figure out what the XPath entry would look like to try
    and filter data for my XMLDataSource. I'm thinking I need to use
    preceding-node somehow, but not quite sure what the syntax would be.
    The xml is below. I want to list all servers for Domain1.

    If I use //STATUS/DOMAIN/servers/server, I get all servers. If I
    use //STATUS/DOMAIN/servers/server[@name='server1'], I get all server1
    servers. How would I format a specific domain?
    I tried //STATUS/DOMAIN[@name='Domain1']/servers/server with no
    success.

    Thanks, Gary


    <?xml version="1.0" standalone="yes "?>
    <?xml-stylesheet type="text/xsl" href="\sheet1.x sl"?>
    <STATUS TITLE="Status">
    <DOMAIN>
    <time>Tue Sep 23 16:03:46 PDT 2008</time>
    <name>Domain1 </name>
    <servers>
    <server>
    <name>server1 </name>
    <state>RUNNIN G</state>
    </server>
    <server>
    <name>server2 </name>
    <state>RUNNIN G</state>
    </server>
    <server>
    <name>server3 </name>
    <state>RUNNIN G</state>
    </server>
    </servers>
    </DOMAIN>
    <DOMAIN>
    <time>Tue Sep 23 16:03:50 PDT 2008</time>
    <name>Domain2 </name>
    <servers>
    <server>
    <name>server1 </name>
    <state>RUNNIN G</state>
    </server>
    <server>
    <name>server2 </name>
    <state>RUNNIN G</state>
    </server>
    </servers>
    </DOMAIN>
    <DOMAIN>
    <time>Tue Sep 23 16:03:51 PDT 2008</time>
    <name>Domain3 </name>
    <servers>
    <server>
    <name>server1 </name>
    <state>NOTRUNNI NG</state>
    </server>
    </servers>
    </DOMAIN>
    </STATUS>


    Tags: None
    • bruce barker
      #2
      Re: XmlDataSource XPath question

      look at xml as a tree,

      //STATUS/DOMAIN[@name='Domain1']

      will return all <DOMAIN>'s with an name attribute = 'Domain'. there are
      no matches in your xml as you have no attributes. try:

      //STATUS/DOMAIN/[name='Domain1']/servers/server

      -- bruce (sqlwork.com)

      Jones wrote:
      Hello,
      >
      I'm trying to figure out what the XPath entry would look like to try
      and filter data for my XMLDataSource. I'm thinking I need to use
      preceding-node somehow, but not quite sure what the syntax would be.
      The xml is below. I want to list all servers for Domain1.
      >
      If I use //STATUS/DOMAIN/servers/server, I get all servers. If I
      use //STATUS/DOMAIN/servers/server[@name='server1'], I get all server1
      servers. How would I format a specific domain?
      I tried //STATUS/DOMAIN[@name='Domain1']/servers/server with no
      success.
      >
      Thanks, Gary
      >
      >
      <?xml version="1.0" standalone="yes "?>
      <?xml-stylesheet type="text/xsl" href="\sheet1.x sl"?>
      <STATUS TITLE="Status">
      <DOMAIN>
      <time>Tue Sep 23 16:03:46 PDT 2008</time>
      <name>Domain1 </name>
      <servers>
      <server>
      <name>server1 </name>
      <state>RUNNIN G</state>
      </server>
      <server>
      <name>server2 </name>
      <state>RUNNIN G</state>
      </server>
      <server>
      <name>server3 </name>
      <state>RUNNIN G</state>
      </server>
      </servers>
      </DOMAIN>
      <DOMAIN>
      <time>Tue Sep 23 16:03:50 PDT 2008</time>
      <name>Domain2 </name>
      <servers>
      <server>
      <name>server1 </name>
      <state>RUNNIN G</state>
      </server>
      <server>
      <name>server2 </name>
      <state>RUNNIN G</state>
      </server>
      </servers>
      </DOMAIN>
      <DOMAIN>
      <time>Tue Sep 23 16:03:51 PDT 2008</time>
      <name>Domain3 </name>
      <servers>
      <server>
      <name>server1 </name>
      <state>NOTRUNNI NG</state>
      </server>
      </servers>
      </DOMAIN>
      </STATUS>
      >
      >

        Comment

        Previous template Next
        Working...