Running of Querries by using javascript / part 1

Hi, 
 
i programmed a "Open Data Access" Driver. It will connected with a Java System. 
The java system is a product managment system, which consist products, orders, prices, etc... 
 
The actual situation: 
 
1. I create a "data source" with the oda driver to the java system. 
 
And now we are comming to my problem: 
 
2. I create a "data set" and type the query inside. 
The product managment system don´t support sql, only a integrate unbeautiful database language. 
 
If i would like to get information of 2 tables (orders, products), I have to create 2 Data Sets: 
(A Data Set integrates a query) 
 
Data Set1: 
select orders of OrderTable 
 
and my Data Set2: 
select products of ProductTable 
 
etc.... 
 
For every query I have to create a new Data Set and therefore a new Query. 
 
That was only a easy example. 
 
In the praxis I have to create more than 10 Data Sets or more. 
(SQL isn´t possible to use) 
 
Is it possible to create with javascript, maybe in the beforeOpen, a script like that: 
 
var array = ["productTable", "orderTable", "priceTable"]; 
var puffer; 
 
for (i=0;i<=10;i++) 
{ 
puffer = select * from array 
//table.add(puffer) 
} 
 
Would you like to say me please, if that steps are possible with BIRT? 
I don´t know the exact code, it is only for demonstration. 
 
Thank you! 
 
Bye

Find more posts tagged with

Comments

JasonW

If you want to iterate over data you have to use a birt dataset. The dataset could be a scripted dataset where you call out to some java class that executes your query though.

NewInBirt

Hi JasonW,

thank you very much for your answer. It makes me happy to know that there is a possibility.

That point is exactly the topic, which i am looking for.

Do you have any hint for me, how to learn that? (Or maybe how can i find a tutorial, which treats this topic)

Best regards

Virgil Dodson

There are a couple of Scripted DataSet examples in the DevShare area of BIRT Exchange. Here is a direct link to one <a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/544-sample-birt-scripted-data-source-example/#description'>Sample BIRT Scripted Data Source Example - Designs & Code - BIRT Exchange</a>

NewInBirt

Hi, 
 
thank you very much for the link. 
The tutorials i have already viewed. But it helped me just a little for my problem. 
 
How is the correct procedure? 
 
I would do this steps: 
 
1. 
Go to the Birt Report Designer and create a new report. 
 
2. 
Create a new Data Source with my Custom ODA Extension. 
 
3. 
Create a new Data Set by using the Data Source of Point 2, 
but how should be the query? 
 
I would create a similar query to the query of the script "beforeOpen". 
query: 
select * from products. 
 
Is that query correct? 
 
4. 
Create a new table with 5 columns by using the palette 
(push the table with 5 columns from the palette into the report) 
 
5. 
Is it right to go to the Data Set Script beforeOpen ? 
Inside of that script I would declare an array and that loop: 
 
Script beforeOpen 
 
var arrayOfSomeTables = {"products", "orders", "prices", "customers", "vendors"} 
 
for (i=0;i<=10;i++) 
{ 
this.queryText = "select * from " + arrayOfSomeTables 
} 
 
But now i have 2 important questions, which i don´t know: 
- How can I call the query within of a loop step? 
- How can I put the result of the query calls to the 5 cells of the table. 
 
Sorry, for the much questions, but i am new to birt. I haven´t found a solution to that problem in the forum or with google search. 
 
Thank you a lot. 
 
Bye 
NewToBirt

NewInBirt

<blockquote class='ipsBlockquote' data-author="JasonW">If you want to iterate over data you have to use a birt dataset. The dataset could be a scripted dataset where you call out to some java class that executes your query though.</blockquote>
 
Hi JasonW, 
 
it isn´t easy to understand everything of your suggestion. 
 
What do you mean with a "scripted dataset"? Is it, a certain data set, where i use a script? 
And which script i have to use by the way? (beforeOpen, beforeClose, onFetch, afterOpen, afterClose) 
 
And within of this script, I import the java-class and iterate with a loop 
above the calling of the query (the calling of the query is following through a java method ). 
 
Is it right? 
 
Hopefully you have a tipp for me. 
 
Best regards 
NewInBirt

JasonW

That is correct, except a scripted data set can be written in JavaScript or Java. So in the beforeOpen you could call like this:

1 - call and get first results in a map
2 - call and get second results in a map

Assuming both maps are the same size iterate over the maps and set the values for all the columns you have. The only problem is you have to know the number of columns you will have prior to building the script. You may want to look at modifying your ODA to support some sql like selecting from multiple tables.

Jason

NewInBirt

JasonW, thank you very much.

I could get it running. Without of your tip, i couldn´t never have done it.

I have just another problem, to put the results to a table. But i want to open a new thread.

Best greetings
NewInBirt