Code

Re: Delete rows in a repeating table that satisfy certain criterion

ricomarcelo — Wed, 20 Jan 2010 19:42:25 GMT

I'm sorry I didn't realize I got a response for my post on this thread. I have to search through my older posts to see it. Anyways, thanks Hilary... I already found a fix for the said problem.

Re: Delete rows in a repeating table that satisfy certain criterion

Hilary Stoupa — Wed, 23 Dec 2009 22:28:43 GMT

Hi:

I'm betting you haven't replaced a sample xpath in the code sample with your own xpath. Where the code sample says:

"/dfs:myFields/dfs:dataFields/d:tblMaster/d:tblDetail"

you need to put in the xpath to your own repeating group. Are you using InfoPath 2003 or 2007? If you are using 2007, you may want to consider using VSTA and managed code rather than jscript. If you need help figuring out the xpath to your repeating group, you can post a screenshot of your Main data source with the folders expanded to show the group you want to delete rows from.

You can attach a file to your reply post under the Options tab.

Re: Delete rows in a repeating table that satisfy certain criterion

ricomarcelo — Tue, 22 Dec 2009 19:17:57 GMT

Hi guys,

I was trying out a jscript version of the code above to delete all rows in my repeating table. So I came up with the following code unfortunately I'm getting an error message:

var rowList = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:tblMaster/d:tblDetail");

for (var row in rowList)

{

row.parentNode.removeChild(row);

}

Can anybody point out what I'm missing? Thanks

Re: Delete rows in a repeating table that satisfy certain criterion

kelsawy2000 — Tue, 03 Nov 2009 09:14:27 GMT

Thank you very much for the xample. It worked for me.

Re: Delete rows in a repeating table that satisfy certain criterion

Jimmy — Tue, 03 Nov 2009 04:08:34 GMT

The code would be something like this:

Dim rowList
Set rowList = XDocument.DOM.selectNodes("/my:myFields/my:group1/my:group2")

For Each row In rowList
     Dim field1Value
     field1Value = row.selectSingleNode("my:field1").text
     Dim field2Value
     field2Value = row.selectSingleNode("my:field2").text

     ' Add your field value checks here
     If (field1Value = "7") or (field1Value = "hello" and field2Value = "2") Then
          row.parentNode.removeChild(row)
     End If
Next

You'll naturally need to use your own appropriate XPath and conditional logic.

Delete rows in a repeating table that satisfy certain criterion

kelsawy2000 — Mon, 02 Nov 2009 06:29:44 GMT

Hello,

I have a form with one button and one repeating table (Table1). The repeating table has textbox and date controls. My data source is

Table1

Textbox1

Date1

I am using VB script. I want to creat a code that, when I click on the button, will DELETE some rows from the repeating table if they satisfy a certain criterion (or criteria) like

* Textbox1 = "this"

* Textbox1 = 1

* Date1 = "4/5/2009"

* Date1 is before three days ago

* Textbox1 = 1 AND Date1="3/5/2009"

Thank you in advance for your help.

Khaled