InfoPath Dev

 I have a simple requirement, but cannot figure out the code:

having a repeating table with several columns and a 'verified' checkbox.

on button click, delete all rows of a repeating table where the checkbox is not checked, so leaving only the rows with checked boxes.

XPathNavigator domNav = MainDataSource.CreateNavigator(); XPathNodeIterator tableRows = domNav.Select("/my:myFields/my:Invoices_List/my:group6", NamespaceManager); DialogResult v = MessageBox.Show("Do you want to erase entire data?", "Invoices Data Table", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (v == DialogResult.Yes) { if (tableRows.Count > 0) { for (int i = tableRows.Count; i > 0; i--) { XPathNavigator reTable = MainDataSource.CreateNavigator(); XPathNavigator reTableRows = reTable.SelectSingleNode("/my:myFields/my:Invoices_List/my:group6[" + i + "]", NamespaceManager); reTableRows.DeleteSelf(); }

Perfect, thanks. So if you just want to get the rows where the checkbox is not true, you would add an XPath filter to your tableRows selector.

Let's pretend the field bound to the checkbox is field3, ok? You could also check that the field = false instead of != true, but I guess I'm assuming any blanks should also be deleted:

XPathNodeIterator tableRows = domNav.Select("/my:myFields/my:Invoices_List/my:group6[my:field3 != 'true']", NamespaceManager);