Qdabra qRules

Re: Deleting a Row in a Repeating Table

Zoidy — Fri, 28 Feb 2014 14:51:29 GMT

Ahhh, was entering it into the Value box! Doh!.

However, I have now pasted the line into the Formula Editor and put the error field onto the view and I'm getting this error:

Action: Delete. Arguments: xpath: /dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems/[2] . Details: Expression must evaluate to a node-set.

UPDATE:

Ignore that error. I re-pasted in the line from your reply above, after ticking Edit Xpath (advanced) and it now works great.

Many thanks for your help.

Cheers,

Pete.

Re: Deleting a Row in a Repeating Table

Jimmy — Fri, 28 Feb 2014 14:32:40 GMT

For the second one, you need to open up the Formula Editor and enter it there, not in the Value: box. Is that where you're entering it?

Note that you can also troubleshoot by dragging the qRules Error field into your form and seeing what it says after you execute a command.

Re: Deleting a Row in a Repeating Table

Zoidy — Fri, 28 Feb 2014 08:01:05 GMT

Hi Jimmy,

That line still doesn't work for me. I'm not getting an error either way. Any other ideas?

Cheers,

Pete.

Re: Deleting a Row in a Repeating Table

Jimmy — Thu, 27 Feb 2014 15:24:09 GMT

Ah, sorry, you need to remove the / after preceding-sibling:: (I imagine InfoPath displayed some sort of error about that?). Fixed it now.

Re: Deleting a Row in a Repeating Table

Zoidy — Thu, 27 Feb 2014 15:16:43 GMT

Many thanks Jimmy, the first one works beautifully.

However the second one is still not doing anything I'm afraid.

Re: Deleting a Row in a Repeating Table

Jimmy — Thu, 27 Feb 2014 14:15:37 GMT

You just need to delete the slashes before the predicates (the parts in [square brackets]):

Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems[@ReceiptNumber = 0] (no concat() needed here)
concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems[", count(preceding-sibling::d:ExpenseItems) + 1 , "]")

Deleting a Row in a Repeating Table

Zoidy — Thu, 27 Feb 2014 13:46:00 GMT

Hi,

I know this has been asked before and I have looked at the answers on those but I am still not getting anywhere.

I would like to delete a row from a repeating table with two different methods:

a.) Delete the same row where a user clicks on an image button in that row.

b.) Delete rows (on submit) where a specific field is empty or zero.

The following command will delete all the rows in the table so I know this at least works:

Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems

But I have tried ...

concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems/[@ReceiptNumber = '", 0, "']")

concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems/[ReceiptNumber='", 0, "']")

concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems/[d:ReceiptNumber='", 0, "']")

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

This is the xpath for the field I am testing this with:

/dfs:myFields/dfs:dataFields/d:ExpensesMain/d:ExpenseItems/@ReceiptNumber

The form is an InfoPath Filler form.

Cheers,

Pete.