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; } } }

Using XML data source element as input for db query

miller

Hi All,
 
I am trying to create a report that has two data sources. One is a XML Resource that provides relevant information for executing the data set of data resource 2 (query on a db).
 
My question here is: How to put the retrieved data element of the XML data source to the relevant query?
 
My idea was putting the retrieved data element into a local variable (scripted) and provide this information as a default parameter in the sql query. Currently it does not work.
 
Are there any standard approaches or easier ways to accomplish this?
 
Thx for the help and regards
Clem

Find more posts tagged with

Comments

micajblock

If there are no items in the report that use the XML data source it will not be executed. Put a table at the top of your report with data from the XML data source (set the visibility to false) and that should work.

miller

Thats all right.. so I am going to set the variable in the onFetch method of my XML data source like reportContext.getAppContext().put("batchID", param["XMLValue"].value); and for the default value of the parameter (in my sql query) I retrieve it with reportContext.getAppContext().get("batchID").
But it is still not working. What am I doing wrong?

micajblock

What version of BIRT are you using?

miller

Hi mblock,
 
I found the problem as I was using the getAppContext.. now with reportContext.setPersistentGlobalVariable and reportContext.getPersistentGlobalVariable my report does work!.
 
Thx