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

Home » Eclipse Projects » 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 18:26

Brad M
Messages: 20
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 01:50

Michael Williams
Messages: 828
Registered: July 2009

Senior Member

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

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

Tue, 05 February 2013 22:30

Brad M
Messages: 20
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 17 times)
Attachment: multi_select_xml.rptdesign
(Size: 9.00KB, Downloaded 14 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 16:31

Michael Williams
Messages: 828
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.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

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 17:26

Brad M
Messages: 20
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 18:00

Michael Williams
Messages: 828
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.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

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 16:56

Brad M
Messages: 20
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 17:59

Michael Williams
Messages: 828
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.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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

Thu, 07 February 2013 21:41

Brad M
Messages: 20
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: Thu, 07 February 2013 21:42]

Report message to a moderator

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

Thu, 07 February 2013 23:31

Michael Williams
Messages: 828
Registered: July 2009

Senior Member

Awesome! Glad to help!

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:	Hierarchy error
Next Topic:	sqljdbc_auth.dll already loaded in another classloader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 18:08:05 EDT 2013