xml node and attribute

[hovikav]

Emailing xml schema separately.

The schema contains a repeating item, note, which has an attribute noteType.

Code: Select all

<xs&#58;element name="note" minOccurs="0" maxOccurs="unbounded">
	<xs&#58;annotation>
		<xs&#58;documentation>If Notes element exists then it must have an attribute of noteType. Only notes with a noteType of REASONS will be processed</xs&#58;documentation>
	</xs&#58;annotation>
	<xs&#58;complexType>
		<xs&#58;simpleContent>
			<xs&#58;extension base="xs&#58;string">
				<xs&#58;attribute name="noteType" type="xs&#58;string" use="required"/>
			</xs&#58;extension>
		</xs&#58;simpleContent>
	</xs&#58;complexType>
</xs&#58;element>

Importing this into an xml resource results in a table, note, which has a single column noteType.

But I need to populate note too. e.g.

Code: Select all

<note noteType="REASONS">First note - This is a note </note>
<note noteType="REASONS">Second note - This is a another note </note>

I expect it's a case of changing xpath, but not obvious where.

Any help will be appreciated.

[Steve]

Hi Hovik,

You need to have the xpath as follows:

/root/parent/note on the table source field, where root and parent are the other xpath location to node.

On the column source field it needs the xpath of .

So in the source field column e.g node.col it has an xpath of:

.

I hope this helps.

Steve

[Steve]

Sorry Hovik,

I misread this and I see it's an attribute...

so I suspect the xpath on the column is:

./[@nodeType]

[hovikav]

Thanks Steve.
As soon as I saw your suggestion I remembered the technique.

This is how I solved it.

Add a new column to the resource: noteValue
Set xpath of this to .
Import it into the form table so it can be populated

No need to touch noteType - it had the correct xpath of @noteType

So the key was the xpath of . for the new resource field.

Thanks again,
Hovik