General

Re: Change a value in a field.

joelundberg — Fri, 01 Jul 2011 19:49:38 GMT

It works great. Thank you very much!!

Re: Change a value in a field.

Jimmy — Fri, 01 Jul 2011 19:18:36 GMT

Sorry, that should have been

xdXDocument:GetDOM("test")/phrases/phrase[@value = current()/dfs:dataFields/d:RATABLE8D/@REASONCODE]

Re: Change a value in a field.

joelundberg — Fri, 01 Jul 2011 17:31:14 GMT

When I change it and click on verify formula it give me: @value" does not point to a valid location path of a field or group.

Re: Change a value in a field.

Jimmy — Fri, 01 Jul 2011 16:16:54 GMT

Hello,

I believe the XPath, when expanded, should look like this:

xdXDocument:GetDOM("test")/phrases[@value = current()/dfs:dataFields/d:RATABLE8D/@REASONCODE]

with just @value after the opening bracket.

Re: Change a value in a field.

joelundberg — Fri, 01 Jul 2011 13:28:50 GMT

-It pulls all the phrases from my xml file. The xml is below. It will list phrase 2,4,&11 in the expression box field. It should be pulling only 11.

       <phrases>
    <phrase value="2">The phrase for ALL</phrase>
    <phrase value="4">The phrase for 2</phrase>
    <phrase value="11">hello</phrase>
</phrases>

Here is my XPath statement:

xdXDocument:GetDOM("test")/phrases[xdXDocument:GetDOM("test")/phrases/phrase/@value = current()/dfs:dataFields/d:RATABLE8D/@REASONCODE]

Re: Change a value in a field.

Jimmy — Fri, 01 Jul 2011 04:10:03 GMT

What do you mean when you say it pulls all the phrase values? Could you attach a screenshot to this thread?

Re: Change a value in a field.

joelundberg — Thu, 30 Jun 2011 20:15:07 GMT

That worked but it pulls all the phrase values from the xml file I created. Any ideas?

Re: Change a value in a field.

Jimmy — Thu, 30 Jun 2011 19:11:30 GMT

You should use the Select field... button to pick the phrase field from the data source, then click Show XPath to add the [@value = current()] part.

I made a mistake in the XPath in my previous post. It should just be:

/phrases/phrase[@value = current()/dbField]

Naturally, you would replace dbField with the actual name of the field where that enumeration is stored.

Re: Change a value in a field.

joelundberg — Thu, 30 Jun 2011 17:47:40 GMT

Thanks Jimmy.

I have created the secondary data source but I am having trouble with the XPath. This is all pretty new to me. What part of the XPath statement has to show my data? I keep getting this formula error ("/phrases/phrase/@value"does not point to a valid location path of a field or group.)

Re: Change a value in a field.

Jimmy — Thu, 30 Jun 2011 16:51:25 GMT

There are two things you can do here:

Bind the field to a Dropdown Box and set up the combobox to have the appropriate display values correspond to all of the numerical "value" values. You can make the dropdown readonly if you don't want anyone changing the value.
Create a secondary data source from an XML file that has all of the phrases like this:
<phrases>
    <phrase value="1">The phrase for 1</phrase>
    <phrase value="2">The phrase for 2</phrase>
</phrases>
And then use an Expression Box (called Calculated Value in IP 2010) to show the corresponding value using an XPath like this:

     /phrases/phrase[@value = current()/dbField]/phrase

Re: Change a value in a field.

joelundberg — Thu, 30 Jun 2011 15:12:06 GMT

The phrases are not in a column. The column consists of the numbers (base enums). Inside of the properties for the numbers are set values that the numbers are tied to.

Re: Change a value in a field.

Patrick Halstead — Wed, 29 Jun 2011 23:43:27 GMT

When you set up the SQL receive connection, did you include the "phrase" column?

Change a value in a field.

joelundberg — Wed, 29 Jun 2011 21:04:30 GMT

I am pulling in data from a SQL server. I have a base enum that consists of about 25 values. When I query on an item in InfoPath it will only give the numeric value of the base enum (I want it to give me the phrase that is tied to it.) I have tried adding rules with conditions but I am having no luck. Any Ideas????