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

CLOB passing

padytom

Trying to pass a 'Fail' and 'pass' from longdescription (CLOB)
 
this
if ("fail" in { Longdescription.ldtext}) then "failed" else "passed"
 
is passing in crystal reports.Same syntax in Birt which is
 
if ('FAIL' in row["LDTEXT"]) {'FAILED'} else {'PASSED'} is giving errors.
 
Any help?

Find more posts tagged with

Comments

JFreeman

What are the specific errors you are receiving?
 
Do you have a sample report you can provide that replicates the issue?

padytom

These are attachments

JFreeman

Instead of using the preview tab, could you run the report by select Run -> View Report -> In Web Viewer.
 
After the error occurs, could you please provide the full error text received within the Error Log and Web Viewer?
 
The 17070 error is a generic failure and the error log should have the full error text and stack trace.

padytom

org.eclipse.birt.data.engine.core.DataException: Fail to compute value for computed column "Time". 
A BIRT exception occurred. See next exception for more information. 
There are errors evaluating script "if ('FAIL' in row["LDTEXT"]) {'FAILED'} else {'PASSED'}": 
TypeError: Can't use instanceof on a non-object.
 at org.eclipse.birt.data.engine.impl.ComputedColumnHelper$ComputedColumnHelperInstance.process(ComputedColumnHelper.java:532)
 at org.eclipse.birt.data.engine.impl.ComputedColumnHelper.process(ComputedColumnHelper.java:137)
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.processFetchEvent(RowResultSet.java:173)
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:126)
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
 at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet$RowResultSetWithResultSetScope.fetch(SimpleResultSet.java:940)
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
 at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.prepareFirstRow(SimpleResultSet.java:309)
 at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.getResultSetIterator(SimpleResultSet.java:328)
 at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1026)
 at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:415)
 at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1167)
 at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
 at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)
 at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:157)
 at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:69)
 at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:338)
 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information. 
There are errors evaluating script "if ('FAIL' in row["LDTEXT"]) {'FAILED'} else {'PASSED'}": 
TypeError: Can't use instanceof on a non-object.
 at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)
 at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evalExpr(ScriptEvalUtil.java:946)
 at org.eclipse.birt.data.engine.impl.ComputedColumnHelper$ComputedColumnHelperInstance.process(ComputedColumnHelper.java:493)
 ... 18 more
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "if ('FAIL' in row["LDTEXT"]) {'FAILED'} else {'PASSED'}": 
TypeError: Can't use instanceof on a non-object.
 at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:295)
 at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:154)
 at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evalExpr(ScriptEvalUtil.java:918)
 ... 19 more
Caused by: org.mozilla.javascript.EcmaError: TypeError: Can't use instanceof on a non-object.
 at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3654)
 at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3632)
 at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3660)
 at org.mozilla.javascript.ScriptRuntime.typeError0(ScriptRuntime.java:3666)
 at org.mozilla.javascript.ScriptRuntime.in(ScriptRuntime.java:2972)
 at org.mozilla.javascript.gen.c958._c0(unnamed script:0)
 at org.mozilla.javascript.gen.c958.call(unnamed script)
 at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
 at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
 at org.mozilla.javascript.gen.c958.call(unnamed script)
 at org.mozilla.javascript.gen.c958.exec(unnamed script)
 at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:290)
 ... 21 more

JFreeman

Thank you for the error text.
 
Instead of using in, you can use indexOf to achieve the same result.
 
For Example:
<pre class="_prettyXprint _lang-js">
if(row["LDTEXT"].indexOf("FAIL") > -1){
"FAILED";
}else{
"PASSED";
}
</pre>

padytom

Thank you for the suggestion. It also gives error

JFreeman

Try encapsulating the code in a null check:
<pre class="_prettyXprint _lang-js">
if(row["LDTEXT"]){
if(row["LDTEXT"].indexOf("FAIL") > -1){
"FAILED";
}else{
"PASSED";
}
}
</pre>

padytom

Please how do I do that? I'm new to many things

JFreeman

The code from my previous post includes the null check.
 
Alternatively, you can also check for null like this to make it a bit more typed out:
<pre class="_prettyXprint _lang-js">
if(row["LDTEXT"] != null){
if(row["LDTEXT"].indexOf("FAIL") > -1){
"FAILED";
}else{
"PASSED";
}
}
</pre>

padytom

Thank you for your support. Been able to solve that problem.

JFreeman

Thank you for the confirmation.
I am glad to hear the issue has been resolved.