Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

Top Categories · View All
SQL Server 146
TSQL 76
SSRS 71
SSIS 68
XML 57

XQuery to find Elements in deferent structure

Jan 20 2014 12:00AM by ve2ram   

Hi,

 I have xml like this

 <?xml version="1.0" encoding="UTF-8"?>

<dtl-topic>
    <title class="- topic/title dtl-topic/title">     Topic_KV   </title>
    <dtl-topic-prolog class="- topic/prolog dtl-topic/dtl-topic-prolog ">
  </dtl-topic-prolog>

<paras id="paras_CA9C4E777A5D4954979A53584E2DADE2" class="- topic/body dtl-topic/paras ">
    <para id="para_2F528A8B1B584B6DBB1FB3B69394ED01" class="- topic/section dtl-topic/para ">
      <p id="p_3441A96174E244599C6EAFF59C97C5D9" class="- topic/p ">
        <xref-DTL type="DTL Content" href="0901ff818055523b#paras_92A9E742E0CA4E00B6B7CD27E7D0ABB1" format="dita" scope="local" class="+ topic/xref dtl-xref/xref-DTL ">This is recalled target</xref-DTL>
        <xref-document type="DTL Content" href="0901ff818055e9de.docx" scope="local" class="+ topic/xref dtl-xref/xref-document ">Reference_Wrapper_KV</xref-document>
      <xref-3rdParty type="DTL Content" href="0901ff818055eaf1#dtl-general_BBC4712C05EE4DA8BC66722A8FBCAED9" format="dita" scope="local" class="+ topic/xref dtl-xref/xref-3rdParty ">General </xref-3rdParty>
      </p>
    </para>
  <para id="para_C8256E3D3ED043BE99030ED09D2523A2" class="- topic/section dtl-topic/para ">
      <p id="p_9137470E56544BA08B32A645F8DBC897" class="- topic/p ">
        <xref-DTL type="DTL Content" href="0901ff818055523a#p_7C9086D21D7C4795BC86283A59DDCB59" format="dita" scope="local" class="+ topic/xref dtl-xref/xref-DTL ">
        Local Link (Changed Text)</xref-DTL>
      </p>
    </para>

<para id="para_C8256E3D3ED043BE99030ED09D2523A2" class="- topic/section dtl-topic/para ">
      <p id="p_9137470E56544BA08B32A645F8DBC897" class="- topic/p ">
      <li>
        <xref-DTL type="DTL Content" href="0901ff818055523a#p_7C9086D21D7C4795BC86283A59DDCB59" format="dita" scope="local" class="+ topic/xref dtl-xref/xref-DTL ">
        Local Link (Changed Text)</xref-DTL>
 </li>

      </p>
    </para>

    </para>
  </paras>

 I want to get the xref count from this documents using XQuery. xref can come any where in the xml. can i know how to achive this?

Submitted under: Microsoft SQL Server · TSQL · XQUERY · XML · 


ve2ram
1808 · 0% · 11

1 Replies

  • What do you mean by "xref count"? Are you looking for the count of XML elements that starts with "xref"? Are you looking for the values that contains "xref"? Please be more specific and mention what is the expected result based on the above input XML.

    commented on Jan 25 2014 9:30PM
    Jacob Sebastian
    1 · 100% · 32235

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]