Help with expression script?

Hello Everyone, 
 
I am new to BIRT (surprise!) and am trying to get the hang of writing expressions. I need to create a computed column called "result" and depending on the result of several variables, this column will have a string value of either "Connected (after hours)", "Connected", "Abandon", "Abandon (after hours)",a calculated string showing connection time, or the default "Not Connected" 
 
Here is the script I am trying to use: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (typeof(row["session_id"]) == "number" && row["open_rule"] == 0)
"Connected (after hours)";
else if (typeOf(row["session_id"]) == "number" && row["open_rule"] == 1)
"Connected";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 1 || row["open_rule"] == "")
"Abandon";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 0)
"Abandon (after hours)";
else if (row["term_pary"] == "SYSTEM" && row["dial_disposition"] != "")
row["dial_disposition"] & "(" & row["dial_duration"] & " sec.)";
else
"Not Connected";
</pre>
 
Any help would be awesome! 
 
Thanks, 
Amanda

Find more posts tagged with

Comments

mwilliams

Hi Amanda,

What is your script currently giving you?

DreamCoder

Hi Michael, 
 
Here is the error I am receiving: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:data.engine.CompCol.FailRetrieveValueComputedColumn
Error Message:Fail to compute value for computed column "result".
A BIRT exception occurred: There are errors evaluating script "if (typeof(row["session_id"]) == "number" && row["open_rule"] == 0)
"Connected (after hours)";
else if (typeOf(row["session_id"]) == "number" && row["open_rule"] == 1)
"Connected";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 1 || row["open_rule"] == "")
"Abandon";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 0)
"Abandon (after hours)";
else if (row["term_pary"] == "SYSTEM" && row["dial_disposition"] != "")
row["dial_disposition"] & "(" & row["dial_duration"] & " sec.)";
else
"Not Connected";":
ReferenceError: "typeOf" is not defined. (<inline>#3).. See next exception for more information.
There are errors evaluating script "if (typeof(row["session_id"]) == "number" && row["open_rule"] == 0)
"Connected (after hours)";
else if (typeOf(row["session_id"]) == "number" && row["open_rule"] == 1)
"Connected";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 1 || row["open_rule"] == "")
"Abandon";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 0)
"Abandon (after hours)";
else if (row["term_pary"] == "SYSTEM" && row["dial_disposition"] != "")
row["dial_disposition"] & "(" & row["dial_duration"] & " sec.)";
else
"Not Connected";":
ReferenceError: "typeOf" is not defined. (<inline>#3).
</pre>
 
It doesn't appear to like "typeOf" which is a javascript function. Basically, what I am trying to do is figure out if row["session_id"] is a number or a string. Do you know of a way I can successfully do this in birt? 
 
Thanks, 
Amanda

bhanley

I am not sure if typeOf(...) is valid. I do not that you can check for number using isNaN(...). Try this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if (!(isNan(row["session_id"])) && row["open_rule"] == 0)
"Connected (after hours)";
else if (!(isNaN(row["session_id"])) && row["open_rule"] == 1)
"Connected";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 1 || row["open_rule"] == "")
"Abandon";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 0)
"Abandon (after hours)";
else if (row["term_pary"] == "SYSTEM" && row["dial_disposition"] != "")
row["dial_disposition"] & "(" & row["dial_duration"] & " sec.)";
else
"Not Connected";</pre>

DreamCoder

Hi Brian, 
 
Thanks for your response. I tried your code and got the following error: 
 
ReferenceError: "isNan" is not defined. (<inline>#1). 
 
Thanks, 
Amanda

DreamCoder

<blockquote class='ipsBlockquote' data-author="DreamCoder">Hi Brian, 
 
Thanks for your response. I tried your code and got the following error: 
 
ReferenceError: "isNan" is not defined. (<inline>#1). 
 
Thanks, 
Amanda</blockquote>
 
Nevermind, I figured it out...just a typo in the code. Its running, tho its not giving me the values I expect so I'll have to troubleshoot some of my logic. 
 
Thanks for your help! 
Amanda

DreamCoder

Hi All, Just wanted to post what my final code looked like. Works like a charm. Thank you to Brian for the assistance: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (!(isNaN(row["session_id"])) && row["open_rule"] == 0)
"Connected (after hours)";
else if (!(isNaN(row["session_id"])) && row["open_rule"] == 1)
"Connected";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 1 || row["open_rule"] == "")
"Abandon";
else if (row["term_party"] == "CALLER" && row["open_rule"] == 0)
"Abandon (after hours)";
else if (row["term_party"] == "SYSTEM" && row["dial_disposition"] != null)
row["dial_disposition"] + "(" + row["dial_duration"] + " sec.)";
else
"Not Connected";
</pre>