Writing Queries

When you open XML Port Manager, the output port area includes a standard query against the XML view, which returns all columns and all rows to OUT1.

Assume that your XML source document contains customer data expressed as attribute values of each data node:

<root>
    <data id="101" fname="Michaels" lname="Devlin"
		address="114 Pioneer Avenue" city="Kingston"
		state="NJ" zip="07070"/>
	<data id="102" fname="Beth" lname="Reiser"

		address="33 Whippany Road" city="Rockwood"
		state="NY" zip="10154"/>
	 <data id="103" fname="Erin" lname="Niedringhaus"
		address="190 Windsor Street" city="Tara"
		state="PA" zip="19301"/>
</root>

To retrieve customer attributes against the XML, you can use a query similar to:

select * from V_XML_CONTENT WHERE TAB_data_ATT_city = 'Kingston'

This query opens the Content Browser, and returns only those rows for which the city value matches Kingston. In the tabular view, you can write a query that looks similar to:

select * from TAB_data where ATT_city='Kingston'

Note:

XML data relationships are generally expressed as parent/child, or as node/attribute relationships. The Content Browser returns XML Port Manager query results as columns and rows. Column and row references refer to query results, not XML data.