Unable to call getFullYear function in date object in scripted dataset open method

Srinivas Yarra

<p>Hi,</p>
<p> </p>
<p>I'm trying to display date as "dd mon yyyy hh:mm:ss"  format from Unix time stamp object using the scripted datasource and dateset. But,I am getting error message while executing report. </p>
<p> </p>
<p>Sample code in open function:</p>
<pre class="_prettyXprint _lang-js">
importPackage(Packages.java.util);
importPackage(Packages.java.lang);
unixtimestamp = "1433324291";//seconds
count = 0;
len = 1;
var myDate = new Date(unixtimestamp*1000);
var year = myDate.getFullYear();
var months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
var month = months[myDate.getMonth()];
var date = myDate.getDate();
var hour = myDate.getHours();
var min = myDate.getMinutes();
var sec = myDate.getSeconds();
var time = date + ',' + month + ' ' + year + ' ' + hour + ':' + min + ':' + sec ;
log("this is my full year :::"+time);
function log(msg){
System.out.println(msg);
}
reportContext.setGlobalVariable("log", log);
</pre>
<p>sample code in fetch function :</p>
<pre class="_prettyXprint _lang-html">
if(count <len) {
row["Timestamp"] = time;
count ++;
return true;
}

return false;
</pre>
<p>Error message: </p>
<div>TypeError: <span style="color:#ff0000;">Cannot find function getFullYear in object Wed Jun 03 15:08:11 IST 2015</span>. (/report/data-sets/script-data-set[@id=&quot;5"]/method[@name=&quot;open"]#7)</div>
<div>at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</div>
<div> </div>
<div>Please find sample report in the attachments.</div>
<div>Environement :- Actuate BIRT Designer Professional and Version: 4.4.0</div>
<div> </div>
<div> </div>
<p> </p>

JFreeman

<p>You can use the BirtDateTime.year() instead to get the desired result.</p>
<p>For example:</p>
<pre class="_prettyXprint _lang-js">
var year = BirtDateTime.year(myDate);
</pre>
<p>I just tested with your sample report and it looks to be working the way you want.</p>
<p> </p>
<p>I also had to modify the scope of the "time" variable you are carrying over into the fetch method. You had it defined as "var time" which makes it local to the open method.</p>
<p> </p>
<p>I've attached a modified version of your sample with these changes in place for reference.</p>