Qdabra qRules

Re: Failed to select the destination node

Hilary Stoupa — Thu, 25 Jan 2018 19:50:15 GMT

Wonderful - glad you have it working! If you use Visual Studio at all, you can run XSLTs to see what the output is - NotePad ++ also has an XML Tools plugin I like that you can use to apply a transform. Sometimes that helps me with debugging. You can use GetXml in qRules to get back sample XML from your secondary data source as well - paste it into a file to use with your XSLT. :)

Re: Failed to select the destination node

zanne — Thu, 25 Jan 2018 19:46:50 GMT

I think I found the issue. Thanks, again!
You are the best!

Re: Failed to select the destination node

zanne — Thu, 25 Jan 2018 19:35:17 GMT

Thanks, Hillary. I checked the data tab and added the repeating table in as a default. Now the data shows twice.

Any thoughts?

Re: Failed to select the destination node

Hilary Stoupa — Thu, 25 Jan 2018 18:40:30 GMT

So, if you right click repeatingTable in the fields task pane & copy XPath, the XPath is: /my:myFields/my:repeatingTable? Since the error says failure to select destination node, that is always the first thing I check. :) The second thing I'd check would be under the Data tab in the ribbon - if you look at the Defaults for the form, is my:repeatingTable included by default?

Failed to select the destination node

zanne — Thu, 25 Jan 2018 18:17:24 GMT

I am getting the error "Failed to select the destination node" on my form.

Here is the command I am using:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=append

Here is the error I'm getting:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.

I looked at the LastWeeksData.xslt file and the xsl looks correct to me. I confirmed the names of the fields in both the form and the secondary list.

Here is the XSLT:

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"
    xmlns:d="http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields"
    xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2016-03-14T16:40:08"

>

<xsl:template match="/">
<my:repeatingTable>
  <xsl:apply-templates select="/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:FormID !='']"/>
</my:repeatingTable>
</xsl:template>

<xsl:template match="d:SharePointListItem_RW">
<my:rtColumns>
  <my:matterNumber>
   <xsl:value-of select="d:ClientMatterNumber"/>
  </my:matterNumber>
  <my:clientName>
   <xsl:value-of select="d:ClientMatterName"/>
  </my:clientName>
  <my:description>
   <xsl:value-of select="d:Description"/>
  </my:description>
  <my:partner>
   <xsl:value-of select="d:Partner"/>
  </my:partner>
  <my:comments>
   <xsl:value-of select="d:Comments"/>
  </my:comments>
  <my:ST>
   <xsl:value-of select="d:ST"/>
  </my:ST>
  <my:LT>
   <xsl:value-of select="d:LT"/>
  </my:LT>
  <my:thisMonth>
   <xsl:value-of select="d:ThisMonth"/>
  </my:thisMonth>
  <my:RowID>
   <xsl:value-of select="d:ID"/>
  </my:RowID>
  <my:FormName>
   <xsl:value-of select="d:FormName"/>
  </my:FormName>

</my:rtColumns>
</xsl:template>

</xsl:stylesheet>

Here is the repeating table node

Here is the source list: