Browser Forms

Re: Iterating Repeating Table Fields coming from Secondary Data Source

infopathdude — Tue, 25 Feb 2014 19:27:17 GMT

Thank you so much Hilary ...thanks for pointing this out... You are awesome

Re: Iterating Repeating Table Fields coming from Secondary Data Source

Hilary Stoupa — Tue, 25 Feb 2014 15:32:05 GMT

In your concat, you are using the full XPath instead of the relative XPath. Instead of:

xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:SupValue

can you try just tns:SupValue?

Re: Iterating Repeating Table Fields coming from Secondary Data Source

infopathdude — Fri, 21 Feb 2014 13:32:34 GMT

Jimmy do you want anymore info to look into this?..Please advise

Re: Iterating Repeating Table Fields coming from Secondary Data Source

infopathdude — Wed, 19 Feb 2014 23:26:32 GMT

Attached is the screenshot of secondary data source and the formula below. Appreciate you looking into it I am looping thru and trying to get AuthorityDesc||SupValue from every row eval(eval(SupUserDOAData, 'concat(xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:AuthorityDesc, "||", xdXDocument:GetDOM("GetAllAuthoritiesByUserAndSupervisor")/dfs:myFields/dfs:dataFields/tns:GetAllAuthoritiesByUserAndSupervisorResponse/tns:GetAllAuthoritiesByUserAndSupervisorResult/tns:SupUserGroupData/tns:Subgroups/tns:SupUserSubgroupData/tns:Authorities/tns:SupUserDOAData/tns:SupValue)'), "..")

Re: Iterating Repeating Table Fields coming from Secondary Data Source

Jimmy — Wed, 19 Feb 2014 15:57:48 GMT

Could you attach a screenshot of the data source you are trying to work with, and the actual full formula you are using?

Iterating Repeating Table Fields coming from Secondary Data Source

infopathdude — Wed, 19 Feb 2014 15:19:33 GMT

Hello there, Have any of you attempted to iterate thru a repeating table and capture column values in a text field using concat to parse it later? I have done this umpteen times with Main DataSource and thought would be the same with Secondary DataSource I used below to make this happen eval(eval(RepeatingGroup, ‘concat(my:Field, “;”)’), “..”) Could there be anything different while using a secondary data source? I have a webservice which returns list of Products and Quantities which need to be updated. Issue I am having when I use the above formula is i just get the same value for every row in the repeating table. Just captures the first row value and repeats for the number of rows. not sure what I am doing wrong...any ideas? Ray