InfoPath Dev

I am getting the subject error when i use concat("Insert /parent=/my:myFields /child=my:Metrics/my:Metric /count=", xdXDocument:GetDOM("ViewOptions")/Util/fields/Count). My count field shows 3, which is correct. I have attached a screen shot of my main data schema. could someone please tell me what i might be doing wrong.

TIA
Dean

Hi Dean,

The Insert command allows insertion of rows in a repeating table. I see your /child path is my:Metrics/my:Metric, which isn't a repeating node. My first guess is that's the reason why the command is failing.

Are you trying to insert  my:Metric or a row in the repeating my:Metrics?

I am trying to insert multiple rows, I get the same error when i use concat("Insert /parent=/my:myFields /child=my:Metrics /count=", xdXDocument:GetDOM("ViewOptions")/Util/fields/Count)

Some additional info, this is on a form that has several dropdowns that are being used to help the user choose the right item. The user is supposed to be able to choose a plan which contains several metrics (the items that should popluate the repeating section. The user will then enter their data into a repeating table that is within the repeating section.

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?

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

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?

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

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?

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

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.

Hilary Stoupa:

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

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.

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?

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

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?