Qdabra qRules

Re: qRules: Delete repeating group inside current repeating group

ErnestoM — Tue, 21 May 2013 12:59:21 GMT

Glad it worked out!

Re: qRules: Delete repeating group inside current repeating group

teylyn — Tue, 21 May 2013 00:05:30 GMT

Hi, thanks for your reply.

I tried this. It builds an XPath, but the current() function returns the value of a text field AND the SharePoint ID field, like this for the Order with the ShPID 9:

xpath: my:myFields/my:Container/my:Orders/my:Order[Joe Bloggs9]/my:OrderDetails/my:OrderDetail

That's weird.

EDIT: It seems that the fields of the record that get populated will make it into the current() function. I moved a few rules that populate the order group below the Delete command and now the generated Xpath looked like this, which did not work

my:myFields/my:Container/my:Orders/my:Order[9]/my:OrderDetails/my:OrderDetail

But that got me on the right track. After some more tinkering, I got it to work with

concat("Delete /xpath=my:myFields/my:Container/my:Orders/my:Order[my:ShPID = ", current(), "]/my:OrderDetails/my:OrderDetail")

Thank you!!

Re: qRules: Delete repeating group inside current repeating group

ErnestoM — Mon, 20 May 2013 12:37:38 GMT

Hi-

You probably need a full xpath:

concat("Delete /xpath=my:myFields/my:Container/my:Orders/my:Order[", current(), "]/my:OrderDetails/my:OrderDetail)

Let us know if this works.

qRules: Delete repeating group inside current repeating group

teylyn — Mon, 20 May 2013 03:03:45 GMT

How do I delete a repeating table that is nested in a repeating section, so I can insert the correct number of rows with the Insert command? I've tried with several Xpath attempts using Current(), but no joy.

My main data source is structured like this:

myFields
 Container
  Orders
   Order (repeating)
    OrderDetails
     OrderDetail (repeating)

The Order node is deleted fine with the qRules Delete command, and then its relevant number of rows are inserted, each containing an empty OrderDetail table showing one row. In the Order repeating table rules I want to use the qRules Delete command to delete the OrderDetail node in the current Order node before it is filled again with Insert. This command does not seem to do anything:

concat("Delete /xpath=", current()/my:OrderDetails/my:OrderDetail)

After the Delete, I run the Insert and populate the rows with data, but the first blank row stubbornly persists. How can I get rid of it?

cheers,