Code

Re: Delete rows when checkbox is false

joubin — Wed, 08 Mar 2023 13:47:23 GMT

quick addition: I had to put: [my:Duty != 1 or my:Duty =null] to cover cases where this strange xsi:nil="true" exists (so node is not empty or 0 but non existent)

Re: Delete rows when checkbox is false

Hilary Stoupa — Tue, 07 Mar 2023 16:21:45 GMT

Ah, cool - so yes, that would depend on your checkbox settings and what you are storing for true / false. Glad you have it working the way you need it to!

Re: Delete rows when checkbox is false

joubin — Tue, 07 Mar 2023 16:14:29 GMT

thanks Hilary, you are a star! it works, just had to change 'true' to '1'. so simple!

Re: Delete rows when checkbox is false

Hilary Stoupa — Tue, 07 Mar 2023 15:27:04 GMT

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);

Re: Delete rows when checkbox is false

joubin — Tue, 07 Mar 2023 08:43:34 GMT

Sure. I'm lucky to found an old Win7 machine with IP2010 (VSTA integrated) installed... it is such a hassle with new 2013 and VisualStudio... currently I have this code, which deletes everything on button click:

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(); }

Re: Delete rows when checkbox is false

Hilary Stoupa — Mon, 06 Mar 2023 16:32:32 GMT

Can you post your current code? I was trying to set up a test, but it looks like I don't have my machine set up correctly for adding code to InfoPath at the moment....

Delete rows when checkbox is false

joubin — Mon, 06 Mar 2023 14:44:25 GMT

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.