blob: cbb052053ab61bbd240b0d16cc0cb237077f99c4 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build &lt;2.6.2.v20110214-1523></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="Merged_group" id="1966">
<property name="FILELIST">C:\git\org.eclipse.mylyn.reviews\r4e\org.eclipse.mylyn.reviews.r4e.report\src\org\eclipse\mylyn\reviews\r4e\report\internal\design\templateDataSource\transformations_Cloning_1\transformations\Merged_group_root.xrer</property>
</oda-data-source>
<oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="Merged_review" id="1967">
<property name="FILELIST">C:\git\org.eclipse.mylyn.reviews\r4e\org.eclipse.mylyn.reviews.r4e.report\src\org\eclipse\mylyn\reviews\r4e\report\internal\design\templateDataSource\transformations_Cloning_1\transformations\Merged\Merged_review.xrer</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Group" id="1968">
<list-property name="computedColumns">
<structure>
<property name="name">GetReviewXmi</property>
<expression name="expression">//Extract the xmiId from the href&#13;
&#13;
val = row["href"];&#13;
spl = val.split ("#");&#13;
if (spl.length == 2 ) {&#13;
ret = spl[1];&#13;
} else {&#13;
ret = ""&#13;
}</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:version</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">filesPrefix</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">GetReviewXmi</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_group</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:version</property>
<property name="nativeName">xmi:version</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</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">4</property>
<property name="name">filesPrefix</property>
<property name="nativeName">filesPrefix</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//ResTrans:ReviewGroupRes]#:#{xmi:version;STRING;@xmi:version},{xmi:id;STRING;@xmi:id},{name;STRING;@name},{filesPrefix;STRING;@filesPrefix},{href;STRING;reviewsRes/@href}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:version</design:name>
<design:position>1</design:position>
<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>xmi:version</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>2</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>name</design:name>
<design:position>3</design:position>
<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:name>filesPrefix</design:name>
<design:position>4</design:position>
<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>filesPrefix</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href</design:name>
<design:position>5</design:position>
<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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment Anomaly" id="1969">
<list-property name="computedColumns">
<structure>
<property name="name">AnomalyType</property>
<expression name="expression">//Convert the anomaly type to a shorten string&#13;
&#13;
// All type start with R4E_CLASS_&#13;
//Strip the beginning of the row type&#13;
str = "R4E_CLASS_";&#13;
&#13;
//ret = row["type"];&#13;
ret = row["xsi:type"]; // ??&#13;
&#13;
if (ret != null ) {&#13;
ar = ret.split(str);&#13;
if (ar.length >1 ) {&#13;
ret = ar[1].toString();&#13;
} else {&#13;
ret = "";&#13;
}&#13;
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">IdentifyRankOther</property>
<expression name="expression">rank = row["rank"]; ret = (rank == null || BirtComp.equalTo(rank != null ? rank.toLowerCase():" -1", "R4E_RANK_NONE".toLowerCase()) ) ? 1: 0;</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">IdentifyRankMinor</property>
<expression name="expression">ret = (row["rank"] == "" || BirtComp.equalTo(row["rank"] != null ? rank.toLowerCase():"-1", "R4E_RANK_MINOR".toLowerCase()) ) ? 1: 0;</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountRankMinor</property>
<expression name="expression">//Count how many were MINOR&#13;
&#13;
Total.sum ( row["IdentifyRankMinor"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountRankMajor</property>
<expression name="expression">//Count how many were MAJOR&#13;
//Adjust the final count&#13;
&#13;
Total.sum ( BirtComp.equalTo( row["rank"], "R4E_RANK_MAJOR" ));</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountRankOther</property>
<expression name="expression">//Count all ranking not equal to MAJOR or MINOR&#13;
Total.sum (row["IdentifyRankOther"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">IdentifyStateCreated</property>
<expression name="expression">//Check state equal to CREATED&#13;
state = row["state"];&#13;
if (state == null ) {&#13;
ret = "R4E_ANOMALY_STATE_CREATED";&#13;
} else if ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_CREATED") ) {&#13;
ret = "R4E_ANOMALY_STATE_CREATED";&#13;
} else {&#13;
ret = "OtherThing"&#13;
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CountStateCreated</property>
<expression name="expression">//Count all state equal to CREATED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["IdentifyStateCreated"], "R4E_ANOMALY_STATE_CREATED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateAssigned</property>
<expression name="expression">//Count all state equal to ASSIGNED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_ASSIGNED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateAccepted</property>
<expression name="expression">//Count all state equal to ACCEPTED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_ACCEPTED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateFixed</property>
<expression name="expression">//Count all state equal to FIXED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_FIXED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateDuplicated</property>
<expression name="expression">//Count all state equal to DUPLICATED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_DUPLICATED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateRejected</property>
<expression name="expression">//Count all state equal to REJECTED &#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_REJECTED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateDeferred</property>
<expression name="expression">//Count all state equal to DEFERRED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_DEFERRED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateVerified</property>
<expression name="expression">//Count all state equal to VERIFIED&#13;
&#13;
Total.count ( BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_VERIFIED") );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountStateOthers</property>
<expression name="expression">//Count all state NOT equal to VERIFIED, Accepted, Assigned , ... or empty&#13;
&#13;
Total.count ( !BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_VERIFIED") &amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_DEFERRED") &amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_REJECTED")&amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_DUPLICATED")&amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_FIXED")&amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_ACCEPTED")&amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_ASSIGNED") &amp;&amp; &#13;
! BirtComp.equalTo( row["state"], "R4E_ANOMALY_STATE_CREATED") &amp;&amp;&#13;
row["state"] != null //For the CREATED STATE &#13;
);</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountTotalAnomaly</property>
<expression name="expression">//Count the total number of anomalies&#13;
&#13;
ret = Total.count ( row["CountRankMajor"] + row["CountRankMinor"] + row["CountRankOther"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">AnomalyDueDate</property>
<expression name="expression">//Adjust the due date format&#13;
//DATE_FORMAT = new SimpleDateFormat ( "dd-MM-yyyy" );&#13;
dueDate = row["dueDate"];&#13;
&#13;
&#13;
if (dueDate != null &amp;&amp; dueDate != "" ) {&#13;
str = "T";&#13;
ar = dueDate.split ( str);&#13;
if (ar != null &amp;&amp; ar != "" ) {&#13;
splitDate = ar[0].toString().split("-");&#13;
if ( splitDate.length >= 3 ) {&#13;
year = splitDate[0];&#13;
month = splitDate[1];&#13;
day = splitDate[2];&#13;
rebuild = year +"/" + month + "/" +day;&#13;
retDate = new Date(rebuild);&#13;
ret = retDate.toLocaleDateString();&#13;
//ret = retDate.toDateString();&#13;
} else {&#13;
ret = "length: " +splitDate.length;&#13;
}&#13;
}&#13;
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">AnomalyState</property>
<expression name="expression">//Convert the anomaly state to a shorten string&#13;
&#13;
// All type start with R4E_Anomaly_State&#13;
//Strip the beginning of the row type&#13;
str = "R4E_ANOMALY_STATE_";&#13;
&#13;
ret = row["state"];&#13;
if (ret != null ) {&#13;
ar = ret.split(str);&#13;
if (ar.length >1 ) {&#13;
ret = ar[1].toString();&#13;
} else {&#13;
ret = "";&#13;
}&#13;
}</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">user</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">review</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">title</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">createdOn</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">rank</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ruleID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">xsi:type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">xsi:type_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">href_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">href_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">state</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">dueDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">fixedInVersion</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">decidedByID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">fixedByID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">followUpByID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">AnomalyType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">IdentifyRankOther</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">IdentifyRankMinor</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">CountRankMinor</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">CountRankMajor</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">CountRankOther</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">IdentifyStateCreated</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">CountStateCreated</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">CountStateAssigned</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">CountStateAccepted</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">30</property>
<property name="name">CountStateFixed</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">31</property>
<property name="name">CountStateDuplicated</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">32</property>
<property name="name">CountStateRejected</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">33</property>
<property name="name">CountStateDeferred</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">34</property>
<property name="name">CountStateVerified</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">35</property>
<property name="name">CountStateOthers</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">36</property>
<property name="name">CountTotalAnomaly</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">37</property>
<property name="name">AnomalyDueDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">38</property>
<property name="name">AnomalyState</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">user</property>
<property name="nativeName">user</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">description</property>
<property name="nativeName">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">review</property>
<property name="nativeName">review</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">title</property>
<property name="nativeName">title</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">createdOn</property>
<property name="nativeName">createdOn</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">rank</property>
<property name="nativeName">rank</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ruleID</property>
<property name="nativeName">ruleID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">xsi:type</property>
<property name="nativeName">xsi:type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">xsi:type_1</property>
<property name="nativeName">xsi:type_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">href_1</property>
<property name="nativeName">href_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">href_2</property>
<property name="nativeName">href_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">state</property>
<property name="nativeName">state</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">dueDate</property>
<property name="nativeName">dueDate</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">fixedInVersion</property>
<property name="nativeName">fixedInVersion</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">decidedByID</property>
<property name="nativeName">decidedByID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">fixedByID</property>
<property name="nativeName">fixedByID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">followUpByID</property>
<property name="nativeName">followUpByID</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EAnomaly]#:#{xmi:id;STRING;@xmi:id},{user;STRING;@user},{description;STRING;@description},{review;STRING;@review},{title;STRING;@title},{createdOn;STRING;@createdOn},{rank;STRING;@rank},{ruleID;STRING;@ruleID},{xsi:type;STRING;type/@xsi:type},{href;STRING;type/@href},{xsi:type_1;STRING;location/@xsi:type},{href_1;STRING;location/@href},{href_2;STRING;id/@href},{state;STRING;@state},{dueDate;STRING;@dueDate},{fixedInVersion;STRING;@fixedInVersion},{decidedByID;STRING;@decidedByID},{fixedByID;STRING;@fixedByID},{followUpByID;STRING;@followUpByID}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>xmi:id</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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>user</design:name>
<design:position>2</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>user</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>description</design:name>
<design:position>3</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>description</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>review</design:name>
<design:position>4</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>review</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>title</design:name>
<design:position>5</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>title</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>createdOn</design:name>
<design:position>6</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>createdOn</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>rank</design:name>
<design:position>7</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>rank</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>ruleID</design:name>
<design:position>8</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>ruleID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>xsi:type</design:name>
<design:position>9</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>xsi:type</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>href</design:name>
<design:position>10</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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>xsi:type_1</design:name>
<design:position>11</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>xsi:type_1</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>href_1</design:name>
<design:position>12</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>href_1</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>href_2</design:name>
<design:position>13</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>href_2</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>state</design:name>
<design:position>14</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>state</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>dueDate</design:name>
<design:position>15</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>dueDate</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>fixedInVersion</design:name>
<design:position>16</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>fixedInVersion</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>decidedByID</design:name>
<design:position>17</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>decidedByID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>fixedByID</design:name>
<design:position>18</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>fixedByID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>followUpByID</design:name>
<design:position>19</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>followUpByID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment FileVersion" id="1970">
<list-property name="computedColumns">
<structure>
<property name="name">CreateHrefFromID</property>
<expression name="expression">//Add # in from of the xmi:id to match the href&#13;
ret = "#" + row["xmi:id"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">platformURI</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">versionID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">repositoryPath</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">localVersionID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CreateHrefFromID</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">platformURI</property>
<property name="nativeName">platformURI</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">versionID</property>
<property name="nativeName">versionID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">repositoryPath</property>
<property name="nativeName">repositoryPath</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</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">6</property>
<property name="name">localVersionID</property>
<property name="nativeName">localVersionID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EFileVersion]#:#{xmi:id;STRING;/@xmi:id},{platformURI;STRING;/@platformURI},{versionID;STRING;/@versionID},{repositoryPath;STRING;/@repositoryPath},{name;STRING;/@name},{localVersionID;STRING;/@localVersionID}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>1</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>platformURI</design:name>
<design:position>2</design:position>
<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>platformURI</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>versionID</design:name>
<design:position>3</design:position>
<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>versionID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>repositoryPath</design:name>
<design:position>4</design:position>
<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>repositoryPath</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>name</design:name>
<design:position>5</design:position>
<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:name>localVersionID</design:name>
<design:position>6</design:position>
<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>localVersionID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment Participant" id="1971">
<list-property name="computedColumns">
<structure>
<property name="name">CountParticipants</property>
<expression name="expression">//Count the number of participants creating anomalies&#13;
&#13;
Total.countDistinct ( row["id"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountAnomalies</property>
<expression name="expression">//Count the number of anomalies being raised&#13;
&#13;
Total.countDistinct ( row["xmi:id"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountAnoPerParticipant</property>
<expression name="expression">//Count How many anomalies (Average) were raised by participants&#13;
&#13;
ret = row["CountAnomalies"] / row["CountParticipants"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">isDecisionParticipant</property>
<expression name="expression">//Count the numberof participant to the DECISION phase&#13;
&#13;
val = row["isPartOfDecision"] != null ? row["isPartOfDecision"] : false;&#13;
&#13;
if (val == "true" ) {&#13;
ret = 1;&#13;
} else {&#13;
ret = 0;&#13;
}</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">GetOrganizer</property>
<property name="dataType">string</property>
<property name="aggregateFunction">FIRST</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">//Test if the first role is an ORGANIZER. If so, let display his ID&#13;
&#13;
//R4E_ROLE_ORGANIZER&#13;
&#13;
if (row["roles"] != null) {&#13;
if ( BirtComp.anyOf(row["roles"], "R4E_ROLE_ORGANIZER" ) ) {&#13;
ret = row["id"];&#13;
}&#13;
}</expression>
</structure>
</list-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">email</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">sequenceIDCounter</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">reviewInstance</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">focusArea</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">reviewedContent</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">roles</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">href_2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">reviewCreatedByMe</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">isPartOfDecision</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">CountParticipants</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">CountAnomalies</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">CountAnoPerParticipant</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">isDecisionParticipant</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">GetOrganizer</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">id</property>
<property name="nativeName">id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">email</property>
<property name="nativeName">email</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">sequenceIDCounter</property>
<property name="nativeName">sequenceIDCounter</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">reviewInstance</property>
<property name="nativeName">reviewInstance</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">focusArea</property>
<property name="nativeName">focusArea</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">reviewedContent</property>
<property name="nativeName">reviewedContent</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">roles</property>
<property name="nativeName">roles</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href_1</property>
<property name="nativeName">href_1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">href_2</property>
<property name="nativeName">href_2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">reviewCreatedByMe</property>
<property name="nativeName">reviewCreatedByMe</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">isPartOfDecision</property>
<property name="nativeName">isPartOfDecision</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EParticipant]#:#{xmi:id;STRING;@xmi:id},{id;STRING;@id},{email;STRING;@email},{sequenceIDCounter;STRING;@sequenceIDCounter},{reviewInstance;STRING;@reviewInstance},{focusArea;STRING;@focusArea},{reviewedContent;STRING;@reviewedContent},{href;STRING;addedComments/@href},{roles;STRING;roles},{href_1;STRING;timeLog/@href},{href_2;STRING;addedItems/@href},{reviewCreatedByMe;STRING;@reviewCreatedByMe},{isPartOfDecision;STRING;@isPartOfDecision}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>1</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>id</design:name>
<design:position>2</design:position>
<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>id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>email</design:name>
<design:position>3</design:position>
<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>email</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>sequenceIDCounter</design:name>
<design:position>4</design:position>
<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>sequenceIDCounter</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>reviewInstance</design:name>
<design:position>5</design:position>
<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>reviewInstance</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>focusArea</design:name>
<design:position>6</design:position>
<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>focusArea</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>reviewedContent</design:name>
<design:position>7</design:position>
<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>reviewedContent</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href</design:name>
<design:position>8</design:position>
<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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>roles</design:name>
<design:position>9</design:position>
<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>roles</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href_1</design:name>
<design:position>10</design:position>
<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>href_1</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href_2</design:name>
<design:position>11</design:position>
<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>href_2</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>reviewCreatedByMe</design:name>
<design:position>12</design:position>
<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>reviewCreatedByMe</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>isPartOfDecision</design:name>
<design:position>13</design:position>
<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>isPartOfDecision</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment TextContent" id="1972">
<list-property name="computedColumns">
<structure>
<property name="name">CreateHrefFomID</property>
<expression name="expression">//Add # in from of the xmi:id to match the href&#13;
ret = "#" + row["xmi:id"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CreateHrefFomID</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4ETextContent]#:#{xmi:id;STRING;@xmi:id},{href;STRING;location/@href}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>1</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href</design:name>
<design:position>2</design:position>
<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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment TextPosition" id="1973">
<list-property name="computedColumns">
<structure>
<property name="name">Count Lines</property>
<expression name="expression">//Count the number of lines &#13;
start = row["startLine"];&#13;
stop = row["endLine"];&#13;
&#13;
nbLines = stop - start;&#13;
&#13;
if (nbLines &lt;= 0 ) {&#13;
nbLines = 1;&#13;
}</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CreateHrefFromPositionID</property>
<expression name="expression">//Add # in front of the xmi-id&#13;
ret = "#" + row["xmi:id"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Line Range</property>
<expression name="expression">//Set the line range for each file&#13;
&#13;
start =row["startLine"];&#13;
end = row["endLine"];&#13;
&#13;
lineRange = start + "-" + end;</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">startPosition</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">length</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">startLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">endLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">Count Lines</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CreateHrefFromPositionID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">Line Range</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">startPosition</property>
<property name="nativeName">startPosition</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">length</property>
<property name="nativeName">length</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">startLine</property>
<property name="nativeName">startLine</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">endLine</property>
<property name="nativeName">endLine</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EAnomalyTextPosition]#:#{xmi:id;STRING;@xmi:id},{startPosition;STRING;@startPosition},{length;STRING;@length},{startLine;STRING;@startLine},{endLine;STRING;@endLine},{href;STRING;file/@href}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>1</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>startPosition</design:name>
<design:position>2</design:position>
<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>startPosition</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>length</design:name>
<design:position>3</design:position>
<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>length</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>startLine</design:name>
<design:position>4</design:position>
<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>startLine</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>endLine</design:name>
<design:position>5</design:position>
<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>endLine</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href</design:name>
<design:position>6</design:position>
<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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Comment Type" id="1974">
<list-property name="computedColumns">
<structure>
<property name="name">ClassErroneous</property>
<expression name="expression">//Identify the ERRONEOUS class anomaly&#13;
&#13;
// row["type"]; //Default value, so the field type is not present&#13;
Total.count ( (row["xmi:id"] != null &amp;&amp; row["type"] == null) || BirtComp.equalTo( row["type"], "R4E_CLASS_ERRONEOUS" ) )</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassSuperfluous</property>
<expression name="expression">//Identify the SUPERFLUOUS class anomaly&#13;
&#13;
Total.count ( BirtComp.equalTo( row["type"], "R4E_CLASS_SUPERFLUOUS" ) );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassImprovement</property>
<expression name="expression">//Identify the IMPROVEMENT class anomaly&#13;
&#13;
Total.count ( BirtComp.equalTo( row["type"], "R4E_CLASS_IMPROVEMENT" ) );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassQuestion</property>
<expression name="expression">//Identify the question class anomaly&#13;
&#13;
Total.count ( BirtComp.equalTo( row["type"], "R4E_CLASS_QUESTION" ) );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassComment</property>
<expression name="expression">//Identify the question class anomaly&#13;
&#13;
Total.count ( BirtComp.equalTo( row["type"], "R4E_CLASS_COMMENT" ) );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassMissing</property>
<expression name="expression">//Identify the question class anomaly&#13;
&#13;
Total.count ( BirtComp.equalTo( row["type"], "R4E_CLASS_MISSING" ) );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">ClassAllButOthers</property>
<expression name="expression">ret = ( row["ClassErroneous"] + row["ClassSuperfluous"] + row["ClassImprovement"] + row["ClassQuestion"] + row["ClassComment"] + row["ClassMissing"]);</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CreateHrefFromXmiID</property>
<expression name="expression">//Create a Href to connect to the anomaly&#13;
&#13;
//Add # in from of the xmi:id to match the href&#13;
ret = "#" + row["xmi:id"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">FormatCommentType</property>
<expression name="expression">//Convert the anomaly type to a shorten string&#13;
&#13;
// All type start with R4E_CLASS_&#13;
//Strip the beginning of the row type&#13;
str = "R4E_CLASS_";&#13;
&#13;
ret = row["type"];&#13;
&#13;
&#13;
if (ret != null ) {&#13;
ar = ret.split(str);&#13;
if (ar.length >1 ) {&#13;
ret = ar[1].toString();&#13;
} else {&#13;
ret = "";&#13;
}&#13;
}</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ClassErroneous</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ClassSuperfluous</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">ClassImprovement</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ClassQuestion</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ClassComment</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ClassMissing</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ClassAllButOthers</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">CreateHrefFromXmiID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">FormatCommentType</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">type</property>
<property name="nativeName">type</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4ECommentType]#:#{xmi:id;STRING;@xmi:id},{type;STRING;@type}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>xmi:id</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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>type</design:name>
<design:position>2</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>type</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Item FileVersion" id="1981">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">platformURI</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">versionID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">repositoryPath</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">localVersionID</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">platformURI</property>
<property name="nativeName">platformURI</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">versionID</property>
<property name="nativeName">versionID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">repositoryPath</property>
<property name="nativeName">repositoryPath</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">localVersionID</property>
<property name="nativeName">localVersionID</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EFileVersion]#:#{xmi:id;STRING;@xmi:id},{platformURI;STRING;@platformURI},{versionID;STRING;@versionID},{repositoryPath;STRING;@repositoryPath},{name;STRING;@name},{localVersionID;STRING;@localVersionID}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>xmi:id</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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>platformURI</design:name>
<design:position>2</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>platformURI</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>versionID</design:name>
<design:position>3</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>versionID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>repositoryPath</design:name>
<design:position>4</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>repositoryPath</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>name</design:name>
<design:position>5</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>localVersionID</design:name>
<design:position>6</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>localVersionID</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Item Participant" id="1982">
<list-property name="computedColumns">
<structure>
<property name="name">RevieItemParticipants</property>
<property name="dataType">integer</property>
<property name="aggregateFunction">COUNTDISTINCT</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">//Count the number of participants adding review items&#13;
&#13;
row["authorRep"]</expression>
</structure>
</list-property>
<expression name="filterExpr">row["authorRep"] != null</expression>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">addedBy</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">review</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">description</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">addedById</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">repositoryRef</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">authorRep</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">submitted</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">href</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href_1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ProjectURIs</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">RevieItemParticipants</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">addedBy</property>
<property name="nativeName">addedBy</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">review</property>
<property name="nativeName">review</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">description</property>
<property name="nativeName">description</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">addedById</property>
<property name="nativeName">addedById</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">repositoryRef</property>
<property name="nativeName">repositoryRef</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">authorRep</property>
<property name="nativeName">authorRep</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">submitted</property>
<property name="nativeName">submitted</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">href</property>
<property name="nativeName">href</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">href_1</property>
<property name="nativeName">href_1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">ProjectURIs</property>
<property name="nativeName">ProjectURIs</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4EItem]#:#{xmi:id;STRING;@xmi:id},{addedBy;STRING;@addedBy},{review;STRING;@review},{description;STRING;@description},{addedById;STRING;@addedById},{repositoryRef;STRING;@repositoryRef},{authorRep;STRING;@authorRep},{submitted;STRING;@submitted},{href;STRING;id/@href},{href_1;STRING;fileContextList/@href},{ProjectURIs;STRING;ProjectURIs}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>xmi:id</design:name>
<design:position>1</design:position>
<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>xmi:id</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>addedBy</design:name>
<design:position>2</design:position>
<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>addedBy</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>review</design:name>
<design:position>3</design:position>
<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>review</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>description</design:name>
<design:position>4</design:position>
<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>description</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>addedById</design:name>
<design:position>5</design:position>
<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>addedById</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>repositoryRef</design:name>
<design:position>6</design:position>
<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>repositoryRef</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>authorRep</design:name>
<design:position>7</design:position>
<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>authorRep</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>submitted</design:name>
<design:position>8</design:position>
<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>submitted</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href</design:name>
<design:position>9</design:position>
<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>href</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>href_1</design:name>
<design:position>10</design:position>
<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>href_1</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ProjectURIs</design:name>
<design:position>11</design:position>
<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>ProjectURIs</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="Item TextPosition" id="1983">
<list-property name="computedColumns">
<structure>
<property name="name">CountFileNumberOfLines</property>
<expression name="expression">//Count the number of lines for teh review item&#13;
start = row["startLine"];&#13;
stop = row["endLine"];&#13;
&#13;
nbLines = stop - start;&#13;
&#13;
if (nbLines &lt;= 0 ) {&#13;
nbLines = 1;&#13;
}</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountTotalLOC</property>
<expression name="expression">//Count the total number of lines&#13;
&#13;
Total.sum ( row["CountFileNumberOfLines"] );</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CountTotalReviewItems</property>
<expression name="expression">//Count the number of review items&#13;
&#13;
Total.countDistinct ( row["startPosition"] , row["startLine"] );</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">startPosition</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">startLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">endLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">length</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">CountFileNumberOfLines</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">CountTotalLOC</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CountTotalReviewItems</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Merged_review</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">xmi:id</property>
<property name="nativeName">xmi:id</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">startPosition</property>
<property name="nativeName">startPosition</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">startLine</property>
<property name="nativeName">startLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">endLine</property>
<property name="nativeName">endLine</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">length</property>
<property name="nativeName">length</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[//r4ecore:R4ETextPosition]#:#{xmi:id;STRING;@xmi:id},{startPosition;STRING;@startPosition},{startLine;STRING;@startLine},{endLine;STRING;@endLine},{length;STRING;@length}#:#<"ResTrans","http:%%org.eclipse.mylyn.reviews.r4e.model.transform%1.0";"xmi","http:%%www.omg.org%XMI";"r4ecore","http:%%org.eclipse.mylyn.reviews.r4e.core.model%";"xsi","http:%%www.w3.org%2001%XMLSchema-instance">]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues