General

Re: Store List value (not ID) in an expression box

Hilary Stoupa — Wed, 26 Oct 2011 18:40:22 GMT

current() is the node that you are currently located at - so, since your expression box is inside a repeating table (bound to a repeating node) - it is the current instance of the node. Here's a link to a blog post that explains it a bit better.

Re: Store List value (not ID) in an expression box

stara — Wed, 26 Oct 2011 18:31:07 GMT

It worked. Thanks so much.

So what does Current() mean - Does it get current value of fk_status?

Thanks a lot,

Re: Store List value (not ID) in an expression box

Hilary Stoupa — Wed, 26 Oct 2011 18:18:15 GMT

Is @fk_review_status in the same repeating table that you are putting the expression box in?

If so, this may work:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status[@pk_review_status = current()/@fk_review_status]/@status_text

But it is hard to know without seeing your form. You can attach a copy of your template to the Options tab if you'd like someone to take a look.

Re: Store List value (not ID) in an expression box

stara — Wed, 26 Oct 2011 18:12:01 GMT

Yes @fk_review_status is in Main data source. I'm using 2003 (Copy xPath is not available). Yes expression box is in the same form in a repeating table.

Thanks

Re: Store List value (not ID) in an expression box

Hilary Stoupa — Wed, 26 Oct 2011 17:51:18 GMT

Where is @fk_review_status located in your main data source? Can you right click on it and select "Copy XPath"? (IP 2007 & 2010)

Where are you placing your expression box on your form? Inside a section? A repeating section or table?

Re: Store List value (not ID) in an expression box

stara — Wed, 26 Oct 2011 17:43:41 GMT

I tried the above. But I get following error message:

"xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status/@fk_review_status" does not point to a valid location path of a field or group.

Thanks

Re: Store List value (not ID) in an expression box

Jimmy — Wed, 26 Oct 2011 16:37:37 GMT

Looks like it should be this:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status[@pk_review_status = @fk_review_status]/@status_text

Store List value (not ID) in an expression box

stara — Wed, 26 Oct 2011 15:49:12 GMT

I have a drop-down list bound to secondary data source and displaying value, but stores ID. How would I store the actual value in an Expression box? Is it possible to achieve this? I used the following formula in expression box but doesn't seem to work:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status/@status_text[@pk_review_status = @fk_review_status]

Note: status_text and pk_review_status are from secondary data source

fk_review_status is in the Main connection (drop down field)

Please let me know if above formula is incorrect.

Thanks

Stara