Qdabra qRules

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 18:22:35 GMT

Oh wonderful! Great job!

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 18:21:03 GMT

Thanks, got it, using the following where SynopisID is on the main form and is the lookup column in the SP List

xdXDocument:GetDOM("GetMetrics")/dfs:myFields/dfs:dataFields/dfs:Metrics[@SynopsisID = xdXDocument:get-DOM()/my:myFields/my:synopsisID][number(xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)]/@ID

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 18:13:17 GMT

I must not be being very clear.

Yes, this can be done. You'll need to use a field for a counter - I think the original document I directed you to does that?

You'll need to use multiple filters, like I mentioned in another earlier post - like group/repeatingGroup[ID = 1][1]/field

So, the filter for the correct ID, and then your counter.

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 18:03:03 GMT

ok, so back to my earlier problem, how to apply a filter and step through the filtered results for each section in the repeating section. can this even be done?

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 17:57:21 GMT

Nope - it is because your form is IP 2007 - it would need to be 2010 to have the query fields.

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 17:52:58 GMT

I'm using IP 2010, but my form is set to IP 2007 Form Filler template because that is what my users have. When I look at the GetMetrics (Secondary) connnection, i just see a dataFields node under the myFields node, Did i miss something when i created this connection?

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 17:47:44 GMT

If you look at the fields task pane for your SharePoint List data connection - do you see the Query fields? Are you using IP 2010 as well? You can use those for equivalency queries - set the SynopsisID query field to the form's SynopsisID and then execute the query to return only the rows that match.

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 17:43:59 GMT

Yes, i'm using SP 2010, what do you mean

Hilary Stoupa:
can you use the query fields to get back just the data you need

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 17:39:05 GMT

Are you using SharePoint 2010? If so, can you use the query fields to get back just the data you need?

You'll still need to use some kind of counter to loop through the items - even if you are filtering on the SynopsisID - since the XPath you are using will only ever get the ID of the first Metrics node from your Metrics list.

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 17:33:40 GMT

My secondary data is coming from a SP list via GetMetrics. this queries the Metrics list that has a lookup column from the Synopsis list.

in the Set ID rule of the repeating section, I'm trying xdXDocument:GetDOM("GetMetrics")/dfs:myFields/dfs:dataFields/dfs:Metrics[@SynopsisID = xdXDocument:get-DOM()/my:myFields/my:synopsisID]/@ID which is getting me closer, but now i getting same data in each of the repeating sections. The SynopsisID is the value from the main form that i am using to filter the items

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 17:26:41 GMT

I think you are right - that you need to either filter the data being returned (not sure what is providing your secondary data, so I can't really speak to that) or you need to use an additional filter when you are setting the value - like group/repeatingGroup[ID = 1][1]/field to get a field value from the first instance of your repeating group where the ID is equal to one... does that make sense?

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 17:12:39 GMT

In the Copy Sharepoint List Values to InfoPath Repeating section fields document, you are getting ALL of the people in the contacts list. In my case, I am populating a repeating section that is effectively a subform so i only want to get a subset of the items in my SP List. I have 2 secondary data connections to SP lists, that are in a 1 to many hierarchy

I added a filter (using an Id value from main form) to the Count rule which is returning the correct number of items from my list (which can vary from 1 to 5 or 6). When i do the insert, i am getting the first items in my list instead of the specific items that i need.The Insert Row command seems to be creating the empty rows that are then populated by the Set values statents for each field, I think that i need to add an additional filter to the set values statements in the repeating section OR when the secondary connection is run

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 16:32:30 GMT

Can you help me understand what this means:

dlgross:
I am able to insert the correct the number of items in the repeating section, but they are the wrong items.

Aren't you just inserting 3 rows? Is the problem when you try to populate the data in the rows you are inserting?

Re: Error: Failed to insert child node

dlgross — Fri, 01 Jun 2012 16:27:18 GMT

THANK YOU, i read the documentation, but since it was optional, i did not realize that it was needed in my scenario. It might help others to expand on this topic in the documentation.

I am able to insert the correct the number of items in the repeating section, but they are the wrong items. I need to apply a filter to the, i think to my Insert row rule, but i'm not sure how do this. Could you please point me to an example?

Thanks

Dean

Re: Error: Failed to insert child node

Hilary Stoupa — Fri, 01 Jun 2012 15:44:23 GMT

Hi there - looks like you need to also include the /before param.

Based on your schema screenshot, I'd think you'd use:

concat("Insert /parent=/my:myFields /child=my:Metrics /before=my:SelfAssessment /count=", xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)

Can you give that a try?