<p>Hi All,</p>
<p> </p>
<p>I am using BIRT RCP 4.3.1 for some report automation.</p>
<p> </p>
<p>Regarding a chart report i get data from ORACLE DB, where the query used has a where clause something as:</p>
<p> </p>
<p>WHERE bus_date between <startDate> and <endDate></p>
<p> </p>
<p>startDate and endDate are report parameters passes by the user.</p>
<p> </p>
<p>However due to the design of the table, the `BETWEEN` clause is taking lot of time and frequently timing out.</p>
<p> </p>
<p>Instead when we are querying like :</p>
<p> </p>
<p>WHERE bus_date = <Date>, this is far quicker.</p>
<p> </p>
<p>Hence i was wondering as how to run this oracle query multiple times in a loop from startDate to endDate and store the result which i can eventually use it in a chart display.</p>
<p> </p>
<p>How can we achieve this?</p>
<p> </p>
<p>I have been working with BIRT for some time now, however never tried out the scripting option in it.</p>
<p> </p>
<p>Can i have a brief about programming in BIRT or some info to get started?</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
