Eclipse Community Forums: BIRT » How to select 2 nodes in XML Dataset

Home » Archived » BIRT » How to select 2 nodes in XML Dataset(Tried setting xpath to //class1|//class2 but it doesn't match)

Show: Today's Messages :: Show Polls :: Message Navigator

How to select 2 nodes in XML Dataset [message #1007204]

Mon, 04 February 2013 23:26

Brad Mising name

Messages: 21
Registered: September 2009

Junior Member

Tried setting xpath (Row Mapping in edit DataSet) to //class1|//class2 but it doesn't match. I get the message on the Column Mapping screen that says: "The table mapping XPath does not exist"

Is there a way to do it?
Thanks
Brad

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007226 is a reply to message #1007204]

Tue, 05 February 2013 06:50

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you show a sample xml file and what you're looking for the result set to be?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007474 is a reply to message #1007226]

Wed, 06 February 2013 03:30

Brad Mising name

Messages: 21
Registered: September 2009

Junior Member

Sample XML:

<root>
	<sampleA>
		<truck>
			<type>alpha</type>
			<wheels>16</wheels>
		</truck>
		<truck>
			<type>beta</type>
			<wheels>14</wheels>
		</truck>
		<car>
			<type>phi</type>
			<wheels>4</wheels>
		</car>
	</sampleA>
	<sampleB>
		<truck>
			<type>gamma</type>
			<wheels>12</wheels>
		</truck>
		<car>
			<type>omega</type>
			<wheels>4</wheels>
		</car>
	</sampleB>
</root>

Example XML and report attached. Attempted to match //truck|//car but get the aforementioned error

Note using BIRT designer 2.6.2 (upgrade path restricted)

Thanks

Attachment: multi_select.xml
(Size: 0.39KB, Downloaded 173 times)
Attachment: multi_select_xml.rptdesign
(Size: 9.00KB, Downloaded 240 times)

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007650 is a reply to message #1007474]

Wed, 06 February 2013 21:31

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Try this as your row mapping expression "/root/*/*"

Then, use //type and //wheels as your columns. That should get you everything.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007659 is a reply to message #1007650]

Wed, 06 February 2013 22:26

Brad Mising name

Messages: 21
Registered: September 2009

Junior Member

Thanks Michael.

I gave an oversimplified example though. What if I want to ignore <bicycle> siblings of car and truck?

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007667 is a reply to message #1007659]

Wed, 06 February 2013 23:00

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Will filtering work as a workaround? It appears that the '|' character is not liked by BIRT. I'll let you know if I get something working.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007879 is a reply to message #1007667]

Thu, 07 February 2013 21:56

Brad Mising name

Messages: 21
Registered: September 2009

Junior Member

Filtering isn't an option unfortunately. A closer workaround would be to search for all instances of a common child element, then referencing its parent:

//nodeUniqueToThoseIWant/..

But this doesn't work either

Looks like I might have to preprocess the data before BIRT

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [message #1007887 is a reply to message #1007879]

Thu, 07 February 2013 22:59

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Ok. If you have a node that is unique to only the ones you want, you should be able to do something like:

//nodeUniqueToThoseYouWant as the row expression.

Then, for the columns, you'd just do ../fieldName1, ../fieldName2, etc.

In this example, I added a <bike> to the xml and added a node to the cars and trucks called property. So, my row xpath was //property and my columns were ../type and ../wheels. This gave me the data for only the cars and trucks that had this node, "property". Hopefully this helps.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: How to select 2 nodes in XML Dataset [SOLVED] [message #1007898 is a reply to message #1007887]

Fri, 08 February 2013 02:41

Brad Mising name

Messages: 21
Registered: September 2009

Junior Member

Hey Michael, that's done it! Just had to check 'suppress duplicates' on the table columns to hide dups and we're in business

Thanks a lot for your help
Brad

[Updated on: Fri, 08 February 2013 02:42]

Report message to a moderator