Table Mapping for XML-Source with Attributes

azique

Hello,

I want to create a DataSet for all 'special' documents, that are documents that have an attribute @type with the value 'special'.

To achieve this I tried to enter the following into the Table Mapping XPath Expression field:
/report/document[@type='special']

This way was also suggested in the book "BIRT - A Field Guide to Reporting" (ISBN 0-321-44-259-8), where the example said "in this example, only books that are in English are selected":
/library/book/title[@lang='eng']

But at the top of the Data Set window it says "The XPath expression "/export/document[@tpye='special']" in invalid. This error message appears as soon as I enter the @-Sign

I am using Birt RCP Designer 2.1.3.

I would be happy about every comment and help!

Thank you,
Johannes

Virgil Dodson

Hi Johannes,

I also can't get the attribute to work when specified on the Table Mapping... however I may have a workaround.

After creating your table mapping to /report/document and select the fields you want returned, you can select the Filter tab, and add a filter where @type = 'special'.