nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

XML Datasource based on query result

keerthink

Hi,
 
Do you have any documentation on how to link a file generated from database as XML file using a query to the Birt DataSource?
The name of the XML file will be different dependent on a unique id for each query. 
 
Also, any information on applying Report Parameters to filter rows for a report using XML Datasource will be highly appreciated.
 
Thanks for any help.

Find more posts tagged with

Comments

Clement Wong

To answer your first question...
It is possible to execute a query to the database in the beforeFactory event. Look at this detailed example in Matthew's reply @ <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35930-running-a-query-in-the-initalize/?p=133369'>http://developer.actuate.com/community/forum/index.php?/topic/35930-running-a-query-in-the-initalize/?p=133369</a>
 
After you execute the query, your result will be the filename (string) and then you can set the name of the XML file to XML Data Source in the beforeFactory, or via the Property Binding of the XML Data Source.
 
As for the second question...
In the XML Data Set's "Edit Data Set" dialog box, you should have the ability to add a Filter condition. The option should be on the left hand side of the dialog between "Parameters" and "Property Binding".