Newbie Questions

Re: Need help with preceding-sibling

Jimmy — Wed, 08 Apr 2015 13:43:44 GMT

Hi Mozzak,

The XPath for that would be

AmendmentGrp[last()]/AmendVerNum

If you're using a browser form and it doesn't like the use of last(), then this one will probably work:

AmendmentGrp[not(following-sibling::my:AmendmentGrp)]/AmendVerNum

Re: Need help with preceding-sibling

Mozzak — Tue, 07 Apr 2015 17:57:29 GMT

Hi Hilary,

You seem like the expert with xpath so I have one more question for you.

The following will give me the value of field AmendVerNum of first row.

AmendmentGrp[1]/AmendVerNum

How can I get the value of the last row ?

thanks again

Re: Need help with preceding-sibling

Mozzak — Mon, 06 Apr 2015 18:50:29 GMT

good idea. Might go that route if I run into other problems with the default value.

thanks again Hilary

Re: Need help with preceding-sibling

Hilary Stoupa — Mon, 06 Apr 2015 18:40:44 GMT

Maybe instead of using this as a default, you could add a rule to the repeating group to set the field to the preceding sibling. Then when the row is inserted, the field gets set.... But if turning off refresh works for you, that's great too. :)

Re: Need help with preceding-sibling

Mozzak — Mon, 06 Apr 2015 18:38:33 GMT

I might have found the solution myself.

I turned off "refresh value when formula is recalculated" and it seems to start working as expected.

is that how to do it?

thanks again

Re: Need help with preceding-sibling

Mozzak — Mon, 06 Apr 2015 18:23:51 GMT

Hi Hilary,

do you mind if I ask for help one more time ?

Everything is working in the filler but once deployed as web form the fields behave strange. For example when I select a dropdown value in the repeating table it jumps back to blank immediately. I assume this is because it is the first row in the table and preceding row does not exist.

How would you work around that problem?

thank you!!

Re: Need help with preceding-sibling

Hilary Stoupa — Thu, 02 Apr 2015 22:47:06 GMT

You bet, glad that helped - for more, you may want to take a look at this: http://zvon.org/xxl/XPathTutorial/Output/example16.html

Re: Need help with preceding-sibling

Mozzak — Thu, 02 Apr 2015 22:41:56 GMT

awesome. it works like a charm.

Bets of all, I know now how the syntax goes.

Thanks so much Hilary.

Re: Need help with preceding-sibling

Hilary Stoupa — Thu, 02 Apr 2015 21:59:59 GMT

Okay, so if you want to set FootprintCommRate to the preceding value:

../preceding-sibling::my:FootprintGrp/my:FootprintCommRate

Re: Need help with preceding-sibling

Mozzak — Thu, 02 Apr 2015 21:49:49 GMT

Thank you Hilary.

So here is the actual example xpath of a field from the repeater table:

/dfs:myFields/my:FootprintGrp/my:FootprintCommRate

Earlier I just used Field1 but it actually is FootprintCommRate.

Thank you so much in advance

Mike

Re: Need help with preceding-sibling

Hilary Stoupa — Thu, 02 Apr 2015 21:07:50 GMT

Right click Field1 in the main data source task pane and select copy XPath - is it really an attribute? Paste the XPath in a reply and I can help you out.

Need help with preceding-sibling

Mozzak — Thu, 02 Apr 2015 20:27:20 GMT

Hi All:

I have a pepeater table and trying to copy the previous row to the new row once a user clicks 'add new row'.

My approach is to set up a formular for each column as default value.

Here is my field structure:

- myFields

-- my:FootprintGrp

----- Field1

----- Field2

So I opened Field1 and added the following formula as a default value:

../preceding-sibling::my:my:FootprintGrp/@Field1

I always receive Validation Errors.

Can someone point me to the right direction ?

thanks,

Mike