Qdabra qRules

Re: Insert node within nested repeating node

Hilary Stoupa — Wed, 12 Jun 2013 23:58:22 GMT

Perfect, glad you are up -n- running. :)

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 23:56:31 GMT

Just wanted to confirm that works great, thanks again

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 23:45:50 GMT

WOW great minds and all that jazz

thanks Hillary

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 23:44:44 GMT

Completed some testing and found the issue. there is a subtotal in the group that preventing from running.

So now need to figure out how to have a subtotal for each of the nested groups as well as the Total for all the expense

Re: Insert node within nested repeating node

Hilary Stoupa — Wed, 12 Jun 2013 23:38:42 GMT

Oh, sorry, your repeating group needs to be the bottom most in your parent group - see attached screenshot. I circled the nodes I moved - then both commands work as anticipated.

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 23:18:46 GMT

I tried the parameter details you gave but still getting error

Failed to insert the child node. Extended Details: Qdabra.Tools.RulesLibrary.RulesLibraryException: Failed to insert the child node. at Qdabra.Tools.RulesLibrary.Commands.PerformInsert(String child, String posn, XPathNavigator parentNode, XPathNavigator childNode, XPathNavigator beforeNode, Int32 position, Int32 insertCount) at Qdabra.Tools.RulesLibrary.Commands.PerformInsertOuter(String child, String before, String posn, String count, XPathNavigator parentNode, XPathNavigator childNode) at Qdabra.Tools.RulesLibrary.Commands.Insert() at Qdabra.Tools.RulesLibrary.Commands.RunCommand(String commandName) at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()
not sure if I am in the right place with the button? here is a link to the xsn if you have time to have a quick look that would be so helpful. MonthlyXSN

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 22:01:12 GMT
excellent thanks Hillary. I wasn't sure of the correct syntax I haven't been able to find any good resources on advanced InfoPath dev, except of course this site.

Re: Insert node within nested repeating node

Hilary Stoupa — Wed, 12 Jun 2013 14:40:21 GMT

I usually use a count of preceding sibling + 1 for this - it really depends on things like where your rule is, what your desired outcome is, etc, but my general approach is like this:
concat("Insert /parent=/my:myFields/my:CCProjectFields/my:CCHeaders[", count(preceding-sibling::my:CCHeaders) + 1, "]/my:CCDetails /xpathsrc=/my:myFields/my:CCProjectFields/my:CCHeaders/my:CCDetails/my:CCDetail")

Re: Insert node within nested repeating node

MrWilde — Wed, 12 Jun 2013 13:33:56 GMT
Ok so how do you establish witch parent gets the row? There will be multiple parents and multiple children for each parent. Only First Parent should receive the command so don't need that. Just not sure of the syntax for the /parent parameter

Re: Insert node within nested repeating node

ErnestoM — Wed, 12 Jun 2013 13:06:22 GMT

Hi-
Yes, CCHeaders is repeating, so we'd need to establish which parent row receives the Insert.
e.g.
/parent=/my:myFields/my:CCProjectFields/my:CCHeaders[1]/my:CCDetails
/parent=/my:myFields/my:CCProjectFields/my:CCHeaders[2]/my:CCDetails
I wonder if the firstparentonly parameter is needed in your scenario.
When the form has a repeating group (child) within a repeating group (parent), the schema may have multiple parents. Executing the Insert command with /firstparentonly set to true (or not declared) means that only the first parent will receive the action specified by the Insert command. If /firstparentonly is set to false, then EVERY parent node will receive the action specified by the Insert command.

Insert node within nested repeating node

MrWilde — Tue, 11 Jun 2013 23:51:41 GMT

I have been looking through the posts for more info regarding this but still missing some bits.

Fields layout attached

I have tried

Insert /parent=/my:myFields/my:CCProjectFields/my:CCHeaders/my:CCDetails /child=my:CCDetail

and also

Insert /parent=/my:myFields/my:CCProjectFields/my:CCHeaders/my:CCDetails /xpathsrc=/my:myFields/my:CCProjectFields/my:CCHeaders/my:CCDetails/my:CCDetail

is there something need in the parent parameter to point to the correct parrent as it is repeating section?