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

Sorting table breaks Javascript

Maciek RadziÅ„ski · 2015-07-29T10:11:34+00:00

Hi, I'm using computed column with definition like: expression <span…

Maciek RadziÅ„ski

Hi,
 
I'm using computed column with definition like: <expression name="expression">try {
params["something_"+row["something"]].value 
} catch (err) {
-1
}</expression>
 
and it works fine.
 
But then, I try to add sorting on different column (in the table, Property Editor -> Sorting).
 
At this point, I get: org.eclipse.birt.report.engine.api.EngineException: Invalid Javascript expression: try {
<div>params["something_"+row["something"]].value </div>
<div>} catch (err) {</div>
<div>-1</div>
<div>}.</div>
<div>Invalid Javascript expression: try {</div>
<div>params["something_"+row["something"]].value </div>
<div>} catch (err) {</div>
<div>-1</div>
<div>}.</div>
<div> </div>
<div>Any ideas?</div>

Find more posts tagged with

Comments

JFreeman

What version of BIRT are you using?
Can you attach a sample report that uses classic models or a flat file data source and replicates this issue?

Maciek RadziÅ„ski

Hi, thank you for your reply.
 
I'm using runtime 4.4.2
 
I created a simple example for you. Now it should fail, but if you remove sorting on table it would be fine.
<div> </div>
<div>Sorry i did not attach it, but I have some problems using this forum</div>
<div> </div>
<div>
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="<a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.23" id="1">
 <property name="createdBy">Eclipse BIRT Designer Version 4.5.0.v201506092134 Build <@BUILD@></property>
 <list-property name="propertyBindings">
 <structure>
 <property name="name">HOME</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">URI</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">DELIMTYPE</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">CHARSET</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">INCLCOLUMNNAME</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">INCLTYPELINE</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">TRAILNULLCOLS</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">OdaConnProfileName</property>
 <property name="id">4</property>
 </structure>
 <structure>
 <property name="name">OdaConnProfileStorePath</property>
 <property name="id">4</property>
 </structure>
 </list-property>
 <property name="units">in</property>
 <property name="iconFile">/templates/blank_report.gif</property>
 <property name="bidiLayoutOrientation">ltr</property>
 <property name="imageDPI">72</property>
 <data-sources>
 <oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="Data Source" id="4">
 <property name="URI">testfile.csv</property>
 <property name="DELIMTYPE">COMMA</property>
 <property name="CHARSET">UTF-8</property>
 <property name="INCLCOLUMNNAME">YES</property>
 <property name="INCLTYPELINE">YES</property>
 <property name="TRAILNULLCOLS">NO</property>
 </oda-data-source>
 </data-sources>
 <data-sets>
 <oda-data-set extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet" name="Data Set" id="5">
 <list-property name="computedColumns">
 <structure>
 <property name="name">treshold</property>
 <expression name="expression">try {
params["something_"+row["name"]].value 
} catch (err) {
-1
}</expression>
 <property name="dataType">string</property>
 </structure>
 </list-property>
 <list-property name="columnHints">
 <structure>
 <property name="columnName">name</property>
 <property name="analysis">dimension</property>
 <text-property name="heading">name</text-property>
 </structure>
 <structure>
 <property name="columnName">somenumber</property>
 <property name="analysis">measure</property>
 <text-property name="heading">somenumber</text-property>
 </structure>
 </list-property>
 <structure name="cachedMetaData">
 <list-property name="resultSet">
 <structure>
 <property name="position">1</property>
 <property name="name">name</property>
 <property name="dataType">string</property>
 </structure>
 <structure>
 <property name="position">2</property>
 <property name="name">somenumber</property>
 <property name="dataType">integer</property>
 </structure>
 <structure>
 <property name="position">3</property>
 <property name="name">treshold</property>
 <property name="dataType">string</property>
 </structure>
 </list-property>
 </structure>
 <property name="dataSource">Data Source</property>
 <list-property name="resultSet">
 <structure>
 <property name="position">1</property>
 <property name="name">name</property>
 <property name="nativeName">name</property>
 <property name="dataType">string</property>
 <property name="nativeDataType">12</property>
 </structure>
 <structure>
 <property name="position">2</property>
 <property name="name">somenumber</property>
 <property name="nativeName">somenumber</property>
 <property name="dataType">integer</property>
 <property name="nativeDataType">4</property>
 </structure>
 </list-property>
 <xml-property name="queryText"><![CDATA[select "name", "somenumber" from "testfile.csv" : {"name","name",STRING;"somenumber","somenumber",INT}]]></xml-property>
 <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="<a data-ipb='nomediaparse' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design"</a><a>xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"></a> 
 <Version>2.0</Version>
 <design:ResultSets derivedMetaData="true">
 <design:resultSetDefinitions>
 <design:resultSetColumns>
 <design:resultColumnDefinitions>
 <design:attributes>
 <design:identifier>
 <design:name>name</design:name>
 <design:position>1</design:position>
 </design:identifier>
 <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
 <design:precision>-1</design:precision>
 <design:scale>-1</design:scale>
 <design:nullability>Unknown</design:nullability>
 </design:attributes>
 <design:usageHints>
 <design:label>name</design:label>
 <design:formattingHints/>
 </design:usageHints>
 </design:resultColumnDefinitions>
 <design:resultColumnDefinitions>
 <design:attributes>
 <design:identifier>
 <design:name>somenumber</design:name>
 <design:position>2</design:position>
 </design:identifier>
 <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
 <design:precision>-1</design:precision>
 <design:scale>-1</design:scale>
 <design:nullability>Unknown</design:nullability>
 </design:attributes>
 <design:usageHints>
 <design:label>somenumber</design:label>
 <design:formattingHints/>
 </design:usageHints>
 </design:resultColumnDefinitions>
 </design:resultSetColumns>
 <design:criteria/>
 </design:resultSetDefinitions>
 </design:ResultSets>
</model:DesignValues>]]></xml-property>
 </oda-data-set>
 </data-sets>
 <page-setup>
 <simple-master-page name="Simple MasterPage" id="2">
 <page-footer>
 <text id="3">
 <property name="contentType">html</property>
 <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
 </text>
 </page-footer>
 </simple-master-page>
 </page-setup>
 <body>
 <table id="6">
 <property name="dataSet">Data Set</property>
 <list-property name="boundDataColumns">
 <structure>
 <property name="name">name</property>
 <text-property name="displayName">name</text-property>
 <expression name="expression" type="javascript">dataSetRow["name"]</expression>
 <property name="dataType">string</property>
 </structure>
 <structure>
 <property name="name">somenumber</property>
 <text-property name="displayName">somenumber</text-property>
 <expression name="expression" type="javascript">dataSetRow["somenumber"]</expression>
 <property name="dataType">integer</property>
 </structure>
 <structure>
 <property name="name">treshold</property>
 <text-property name="displayName">treshold</text-property>
 <expression name="expression" type="javascript">dataSetRow["treshold"]</expression>
 <property name="dataType">string</property>
 </structure>
 </list-property>
 <list-property name="sort">
 <structure>
 <expression name="key" type="javascript">row["somenumber"]</expression>
 <property name="direction">asc</property>
 <property name="strength">-1</property>
 </structure>
 </list-property>
 <column id="25"/>
 <column id="26"/>
 <column id="27"/>
 <header>
 <row id="7">
 &

JFreeman

Send me a private message with the issues you are having with the forums and I will help address those.

Regarding this question, I will dig deeper and see if there is a way to work around the issue you are facing.