Qdabra qRules

Re: Delete row from a repeating table using QRules

Daniel_5584 — Wed, 02 Jan 2019 18:33:58 GMT

Hi Hillary,

Thank you for help. That did the trick. I figured my xpath was off.

When I ran into trouble deleting the rows based on empty fields I tried setting the field DeleteRow to the word "DELETE" and then using a rule to delete the specific row. Which works sort of, but based on order of operations for rules and code it will only delete a single row with each button press.

Thanks again for all your help!

Happy New Year!

Dan

Re: Delete row from a repeating table using QRules

Hilary Stoupa — Mon, 31 Dec 2018 15:58:14 GMT

So - the repeating group is Prod_Info_Display? I'm not sure what your DeleteRow field is for, but if Prod_Info_Display is the repeating group, and you want to delete rows where PN_Display is blank, I'd try: Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display[my:PN_Display='']

Re: Delete row from a repeating table using QRules

Daniel_5584 — Sat, 22 Dec 2018 01:02:59 GMT

Is it possible to delete a given row from outside the repeating table using QRules?

I would like to delete all blank rows of a table using a button that is outside the table. I know the SetValue command can use a criterion filter, is it possible to do the same with the Delete command?

What I am trying is this:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display/my:DeleteRow[../my:PN_Display='']

The first time I press the Button the Success box is checked, but nothing seems to happen. On the second press I receive the error: Could not locate field to delete.

I can delete the entire table with:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display

Or a specific row with:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display[3]

But I can't figure out how to delete a row when it is blank from outside of the repeating table. Any help is greatly appreciated!

Re: Delete row from a repeating table using QRules

cawboy — Wed, 19 Mar 2014 12:37:08 GMT

where i must insert this command ?

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

for delete an item with infopath form 2010

Jimmy:
Assuming you have the delete button in each row of the repeating table, it would be something like:

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

Re: Delete row from a repeating table using QRules

Hilary Stoupa — Tue, 17 Jan 2012 22:03:25 GMT

That's great news - I'm glad you got it all working the way you want it to!

Re: Delete row from a repeating table using QRules

Leinweber — Tue, 17 Jan 2012 21:55:03 GMT

Thank you Hilary and Patrick! I understand know and was able to get everything to work. :) I greatly appreciate your help with this.

Re: Delete row from a repeating table using QRules

Hilary Stoupa — Mon, 16 Jan 2012 16:20:05 GMT

Hi - just so you know, the SubmitToSharePointList and the companion refresh command are only for use on the Main data source. That means you'd need to copy the SharePoint items into your form's main data source.

So, you could add a repeating group to your main data source and use the CopyTable to copy in the information from the 2DS. Include the IDs, since the refresh command and the submit command will need them in order to know what item you want to delete or update.

Then, after you've copied your items in, running the Refresh command will generate the internal list that Patrick mentions. Allow users to delete, update or add items, and the SubmitToSharePointList command will replicate those changes in your SharePoint list. Hope that helps, please let me know where you could use more info.

Re: Delete row from a repeating table using QRules

Patrick Halstead — Sun, 15 Jan 2012 16:09:47 GMT

Hi Leinweber, According to an email from Hilary: "in general, use the refresh command on form open, the delete command to remove the list item from the form (or just delete the row) then the SubmitToSharePointList command to actually delete from the list. This user may not be submitting again. Refresh creates a list of all your current linked items so that Submit knows what to delete. " One of us should be able to respond in further detail (or give a demo) sometime next week. Thanks, P

Re: Delete row from a repeating table using QRules

Leinweber — Sun, 15 Jan 2012 01:57:45 GMT

Doing some reading and realize the Delete command will not remove the record from the SharePoint list, just from the XML node and that I need to work with RefreshSharePointListItem to do what I want.

However, I am lost. I am not able get the a SharePoint list item to get removed and no error, result or success indicators are being generated. I don't know if the trouble is my xpath Delete call or in my use of RefreshSharePointList. How can I debug this? I don't know how to tell f the xpath delete is working or not ... or if the RefreshSharePointList call is working or not. What can I do to figure this out?

Re: Delete row from a repeating table using QRules

Leinweber — Sat, 14 Jan 2012 19:12:17 GMT

Would this work if I am popluating my repeating table with data from a SharePoint list? I have a repeating table that is bound to a data connection that pulls rows from a SharePoint list. I want my InfoPath form users to be able to delete rows in the SharePoint list from the form. I added a button with an on-click rule to run the following Qdabra command:

concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[", count(preceding-sibling::SharePointListItem_RW) + 1, "]")

When I preview my form, the data from the SharePoint list is displayed in the repeating table with a delete button next to each record. When I click on the delete button ... well nothing happens. The data stays in the SharePoint List and no information is displayed in the Qdabra Results, Success, or Error controls I have placed at the bottom of the form to help me debug the issue.

Am I going about this the right way? Is there a different way I should be doing this?

Re: Delete row from a repeating table using QRules

Jimmy — Wed, 04 Jan 2012 15:33:09 GMT

That's odd. I wouldn't expect it to need a space before the comma there. At any rate, I'm glad it helped!

Re: Delete row from a repeating table using QRules

Jeroen de Lang — Wed, 04 Jan 2012 14:54:24 GMT

Got it! Only thing the example needed was a space before the final comma to pass the formula validation (apart from the correct XPath of course).

Thanks!

Re: Delete row from a repeating table using QRules

Jimmy — Wed, 04 Jan 2012 13:02:44 GMT

Assuming you have the delete button in each row of the repeating table, it would be something like:

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

Delete row from a repeating table using QRules

Jeroen de Lang — Wed, 04 Jan 2012 12:47:32 GMT

I have searched the forums and the Internet, but somehow the answers eludes me. How can i make a Rule that only deletes the current row in a repeating table? I can delete a specific line number, but how to retrieve that?