General

Re: Filtering external datasource in repeating table not working

mwitt — Sun, 13 Dec 2015 15:29:00 GMT

Hi Hilary, I think you got it immediately, as you initial suggestion solved my problem:-)!

Thanks a lot, what I did not get was that I needed to replace the full path.

Best regards

/Micke

Re: Filtering external datasource in repeating table not working

Hilary Stoupa — Fri, 11 Dec 2015 16:51:23 GMT

Sorry, I'm still having a hard time understanding. Did the formula I provided help? "current()" always refers to the current field. So, in a default value using the formula above, to get another field in the same group as the field we've put the default in, we use "current()" to get the current node, "/../" to move back up to the repeating group2, then "my:architecture" to select the architecture node in the same repeating group2 node as the current field.

Re: Filtering external datasource in repeating table not working

mwitt — Fri, 11 Dec 2015 08:44:41 GMT

Hi Hilary and thanks for your fast reply. I can not attach the file as it contains sensitive info, but I will try to clarify this better;

I have a repeating table, lets call it table1.

I table1 I have four columns with fields, lets call them fieldA, fieldB, fieldC and fieldD

Table1 data is also added as a repeating section further down in the same form, lets call it section1.

In section1, fieldA, fieldB, fieldC and fieldD is also shown.

In section1 I also have additional fields, tied to the same repeating data source (table1), lets call this fieldE.

To populate fieldE, I have an external data source in the form of a sharepoint list, lets call this list1.

The xpath above is the default value logic applied to fieldE to filter out the correct value form list1 using information from fieldA & fieldB & a static text value.

What I need to understand is how to reference fieldA and fieldB per row as rows and sections are added by the users.

In the xpath below, fieldE = Number_x0020_of_x0020_servers

fieldA = architecture

fieldB = hw_capacity

xdXDocument:GetDOM("SIEM hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Number_x0020_of_x0020_servers[contains(../d:Title, "Index") and ../d:Deployment_x0020_type = current()/../my:architecture and ../d:deployment_x0020_size_x0020__x00 = current()/../my:hw_capacity]

Best regards

/Micke

Re: Filtering external datasource in repeating table not working

Hilary Stoupa — Thu, 10 Dec 2015 20:04:27 GMT

What is repeating in your main data source? group2? Where is the formula you posted being used? In a rule or as a default value? I'm asking because I can help you with this - but what the XPath would be depends on where it is used. If, for example, you have a field in group2 that has a default using this, it would be:

Filtering external datasource in repeating table not working

mwitt — Thu, 10 Dec 2015 15:52:43 GMT

Hi,

New to this forum, so I post this in the general section and hope you can move it to the correct place.

I´m not a developer, but are using InfoPath 2013 to enhance some internal business processes, but not doing any coding. I have run in to a tricky problem that I have not been able to solve, even after reading a lot of posts here and in other places.

I have a form where I use a repeating table with 4 different fields. The same repeating table is also inserted further down in the form as a repeating section where a lot of additional fields are used to populate detailed data.

In the repeating section I have fields where I try to filter out results from a connected sharepoint list based on values in the repeating table. When I only have one row, it works fine, but as soon as I add additional items, it seems to pick up the values from the firs row only in the filtering rules.

It seems that I need to use the current () function to reference the individual rows to get the filter to work on each individual repeating row/repeating section, but I cant figure out how to do this.

This is the x-path for the filed that I want to auto-populate based on filtering of the external datasource:

xdXDocument:GetDOM("SIEM hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Number_x0020_of_x0020_servers[contains(../d:Title, "Index") and ../d:Deployment_x0020_type = xdXDocument:get-DOM()/my:myFields/my:datacenters/my:group2/my:architecture and ../d:deployment_x0020_size_x0020__x00 = xdXDocument:get-DOM()/my:myFields/my:datacenters/my:group2/my:hw_capacity]

As you can see, I use three different filtering criteria's to identify the correct info.

Hope someone can help out.

Best regards

/Micke