Extracting data from a Infopath Form Repeating Section

[David]

I am trying to extract data from a Infopath Form Repeating Section that has
been submited to a Form Library. We can extract data from the Sharepoint SQL
database for all fields except fields in a repeating section.

How can one query fields in a repeating section of an Infopath Form that is
in a Form Library?

The Data Structure is similar as shown below
Form 1
Date
Requester Name
Repeating Section
Material Name (1) (Repeating Section)
Material ID (1) (Repeating Section)
Material Name (2) (Repeating Section)
Material ID (2) (Repeating Section)
Form 2
Date
Requester Name
Repeating Section
Material Name (1) (Repeating Section)
Material ID (1) (Repeating Section)
Material Name (2) (Repeating Section)
Material ID (2) (Repeating Section)
Material Name (3) (Repeating Section)
Material ID (3) (Repeating Section)

 

[Shiva[autonomysystems.com]]

Hi David,

You can get the repeating section node through using code as below:

IXMLDOMDocument2 secondaryDOM = thisXDocument.GetDOM("Secondary DOM
Connection Name");
secondaryDOM.setProperty("SelectionNameSpaces", "Namespace of the secondary
dom");
IXMLDOMNodeList repeatingNodes = secondaryDOM.selectNodes("XPath of your
repeating section node");

 

[David]

Where do you place that code?

Hi David,

You can get the repeating section node through using code as below:

IXMLDOMDocument2 secondaryDOM = thisXDocument.GetDOM("Secondary DOM
Connection Name");
secondaryDOM.setProperty("SelectionNameSpaces", "Namespace of the secondary
dom");
IXMLDOMNodeList repeatingNodes = secondaryDOM.selectNodes("XPath of your
repeating section node");