InfoPath Dev

Hi

I want to get the value of a field for all records in a repeating table. In my current repeating table there are 3 records.

I use the following code to try to retrieve the value of the field for each record but it only ever gets the value of the 1st record in the repeating table:

var Records = XDocument.DOM.selectNodes("/my:myFields/my:Itemisations/my:ItemisationsTable");

for (var i=0; i < Records.length; i++)

{

var blah = Records[i].selectSingleNode("/my:myFields/my:Itemisations/my:ItemisationsTable/my:AllocationDetails/my:PaymentMethod");

//note that the below I have used for debugging to verify the value of the field..... 

//FileObject.Write(blah.text + "\t");

 }

What am I doing wrong here? It is only ever showing the field value of the 1st record in the repeating table???

For "blah" you are iterating through all the records nodes and then going back up to your main node to select the value -- which always returns the first value. The selectSingleNode for that variable should be from Records[i], so: "my:AllocationDetails/my:PaymentMethod"

Hi Hilary

Thanks for your reply.  I still need further directions.  What do you mean by so: "my:AllocationDetails/my:PaymentMethod"?

Appreciate your help

Phil

Oh, sure. I mean the code above should read thus:

var Records = XDocument.DOM.selectNodes("/my:myFields/my:Itemisations/my:ItemisationsTable");

for (var i=0; i < Records.length; i++)

{

var blah = Records[i].selectSingleNode("my:AllocationDetails/my:PaymentMethod");

//note that the below I have used for debugging to verify the value of the field..... 

//FileObject.Write(blah.text + "\t");

 }

Because, you see, your variable called Records refers to the ItemisationsTable node. So, as you iterate through, you want to be setting your new variable to the PaymentMethod node that belongs to the record node you are currently looking at....

Okay Hilary,

Tried your suggestion, at first it was not writing anything, however, I replaced [i] in the var blah line with 0 then 1 and yes it was writing the selected row accordingly.  I changed it back to [i] and its working!??  Thank you big time!

I am hampered by my next step however,  I am trying to write a row of fields from a repeating table separated by tabs ("\t") and then start a new line ("\r" + "\n") before the next row of data is written and so forth  In others words, a tab delimited text file output.  I can't seem to enable my var blah to include the tab and another field.

Please advise.

Regards - Phil

Try doing this: 

var Records = XDocument.DOM.selectNodes

("/my:myFields/my:Itemisations/my:ItemisationsTable");

 

for (var i=0; i < Records.length; i++) {  FileObject.Write(Records[i].selectSingleNode("my:AllocationDetails/my:PaymentMethod").text + "\t");

 

//…then repeat this for all the other fields except the last one …..

 

//..then for the last one ensure you put the newline characters instead of the tab:

 

FileObject.Write(Records[i].selectSingleNode("my:AllocationDetails/my:YourLastField").text + "\r” + “\n”);

 }

 

 

Hey Josh,

That did it! Thank you!  & Thank you Hilary!  You have both helped me enormously!

Regards - Phil