Home » Archived » BIRT » Empty first page
Empty first page [message #656463] |
Fri, 25 February 2011 13:49  |
Eclipse User |
|
|
|
After upgrading BIRT from version 2.3.2 to 2.6.1, some reports have started producing empty first pages. I've checked the source XML of the rptdesign and the referenced rptlibrary and verified that ALL settings of page break properties are set to "auto". I.e. there are no forced page breaks anywhere in the report definition. The first page contains the master page header/footer items but no data.
Being a relative newbie to BIRT I'm not sure where to go next to solve (or even debug) this problem. My Google-fu turns up some old bugs (2.1 timeframe) relating to blank first pages but they were resolved long ago.
I have some screenshots but this system doesn't seem to allow attachments.
[Updated on: Fri, 25 February 2011 14:01] by Moderator
|
|
| | |
Re: Empty first page [message #656484 is a reply to message #656476] |
Fri, 25 February 2011 15:46   |
Eclipse User |
|
|
|
Here it is... (I wish there were a way to attach a zip file instead)
<?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.1.v20100902 Build <2.6.1.v20100915-1750></property>
<property name="units">in</property>
<property name="theme">troux_core.Troux Theme</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<list-property name="libraries">
<structure>
<property name="fileName">troux_core.rptlibrary</property>
<property name="namespace">troux_core</property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="BlueprintID" id="927">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">1</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="concealValue">true</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Categories" id="929">
<property name="valueType">dynamic</property>
<property name="dataSetName">Prompt Categories Data Set</property>
<expression name="valueExpr">dataSetRow["STANDARDS_CATEGORY_ID"]</expression>
<expression name="labelExpr">dataSetRow["STANDARDS_CATEGORY_NAME"]</expression>
<property name="dataType">decimal</property>
<property name="distinct">true</property>
<property name="paramType">multi-value</property>
<property name="controlType">list-box</property>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Troux Datamart" id="7"
extends="troux_core.Troux Datamart"/>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Catalog Data Set" id="652">
<list-property name="filter">
<structure>
<property name="operator">in</property>
<expression name="expr">row["CAT_ID"]</expression>
<simple-property-list name="value1">
<value>params["Categories"].value</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CAT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CAT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRODUCT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCT_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">MANUF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">MANUF_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MANUF_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MANUF_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">VERSION_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">VERSION_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">VERSION_ALIAS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">VERSION_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">VERSION_VERSION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">VERSION_SCOPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">VERSION_USAGE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">VERSION_PATCH</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">VERSION_LAST_REVIEW</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">VERSION_REVIEW_NOTES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">VERSION_REVIEW_CYCLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">STEWARD_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">STEWARD_TITLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">STEWARD_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">STEWARD_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">VENDOR_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">VENDOR_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">VENDOR_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">VENDOR_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PHASE_TYPE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[if ( this.queryText.contains("{fn ") ) {
try {
var trouxReportContext = Packages.com.troux.common.utils.ReportContext.getTrouxReportContext(reportContext.getAppContext());
this.queryText = trouxReportContext.dbSpecific(this.getDataSource().getName(), this.queryText);
} catch (e) {
this.queryText = this.queryText.replace("{fn dbDate}", "getdate()");
this.queryText = this.queryText.replace("{fn dbDate}", "getdate()");
}
}]]></method>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CAT_ID</property>
<property name="nativeName">CAT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CAT_NAME</property>
<property name="nativeName">CAT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">PRODUCT_ID</property>
<property name="nativeName">PRODUCT_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PRODUCT_NAME</property>
<property name="nativeName">PRODUCT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PRODUCT_DESC</property>
<property name="nativeName">PRODUCT_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">MANUF_NAME</property>
<property name="nativeName">MANUF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">MANUF_CONTACT</property>
<property name="nativeName">MANUF_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">MANUF_EMAIL</property>
<property name="nativeName">MANUF_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">MANUF_PHONE</property>
<property name="nativeName">MANUF_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">VERSION_ID</property>
<property name="nativeName">VERSION_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">VERSION_NAME</property>
<property name="nativeName">VERSION_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">VERSION_ALIAS</property>
<property name="nativeName">VERSION_ALIAS</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">VERSION_DESC</property>
<property name="nativeName">VERSION_DESC</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">VERSION_VERSION</property>
<property name="nativeName">VERSION_VERSION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">VERSION_SCOPE</property>
<property name="nativeName">VERSION_SCOPE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">VERSION_USAGE</property>
<property name="nativeName">VERSION_USAGE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">VERSION_PATCH</property>
<property name="nativeName">VERSION_PATCH</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">VERSION_LAST_REVIEW</property>
<property name="nativeName">VERSION_LAST_REVIEW</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">VERSION_REVIEW_NOTES</property>
<property name="nativeName">VERSION_REVIEW_NOTES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">20</property>
<property name="name">VERSION_REVIEW_CYCLE</property>
<property name="nativeName">VERSION_REVIEW_CYCLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">21</property>
<property name="name">STEWARD_NAME</property>
<property name="nativeName">STEWARD_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">22</property>
<property name="name">STEWARD_TITLE</property>
<property name="nativeName">STEWARD_TITLE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">23</property>
<property name="name">STEWARD_PHONE</property>
<property name="nativeName">STEWARD_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">24</property>
<property name="name">STEWARD_EMAIL</property>
<property name="nativeName">STEWARD_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">25</property>
<property name="name">VENDOR_NAME</property>
<property name="nativeName">VENDOR_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">26</property>
<property name="name">VENDOR_CONTACT</property>
<property name="nativeName">VENDOR_CONTACT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">27</property>
<property name="name">VENDOR_EMAIL</property>
<property name="nativeName">VENDOR_EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">28</property>
<property name="name">VENDOR_PHONE</property>
<property name="nativeName">VENDOR_PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">29</property>
<property name="name">PHASE_TYPE</property>
<property name="nativeName">PHASE_TYPE</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
SC.STANDARDS_CATEGORY_ID CAT_ID,
SC.STANDARDS_CATEGORY_NAME CAT_NAME,
ITP.HARDWARE_PRODUCT_COMPONENT_ID PRODUCT_ID,
ITP.HARDWARE_PRODUCT_COMPONENT_NAM PRODUCT_NAME,
ITP.HARDWARE_PRODUCT_DESCRIPTION PRODUCT_DESC,
MAN.EXTERNAL_ORG_COMP_NAME MANUF_NAME,
MAN.EXTERNAL_ORGANIZATION_CONTACT MANUF_CONTACT,
MAN.EXTERNAL_ORGANIZATION_EMAIL_AD MANUF_EMAIL,
MAN.EXTERNAL_ORGANIZATION_PHONE MANUF_PHONE,
VER.HARDWARE_PRODUCT_MODEL_ID VERSION_ID,
VER.HARDWARE_PRODUCT_MODEL_NAME VERSION_NAME,
VER.HARDWARE_PRODUCT_MODEL_ALIAS VERSION_ALIAS,
VER.HARDWARE_PRODUCT_MODEL_DESC VERSION_DESC,
VER.HARDWARE_PRODUCT_MODEL_VERSION VERSION_VERSION,
VER.STANDARD_CANDIDATE_SCOPE VERSION_SCOPE,
VER.STANDARD_CANDIDATE_USAGE_GUIDE VERSION_USAGE,
VER.STANDARD_CANDIDATE_REC_PATCH VERSION_PATCH,
VER.STANDARD_CANDIDATE_LAST_REVIEW VERSION_LAST_REVIEW,
VER.STANDARD_CANDIDATE_REVIEW_NOTE VERSION_REVIEW_NOTES,
VER.STANDARD_CANDIDATE_REV_CYC VERSION_REVIEW_CYCLE,
P.PERSON_COMPONENT_NAME STEWARD_NAME,
P.PERSON_BUSINESS_TITLE STEWARD_TITLE,
P.PERSON_OFFICE_PHONE_NUMBER STEWARD_PHONE,
P.PERSON_EMAIL_ADDRESS STEWARD_EMAIL,
VEN.EXTERNAL_ORG_COMP_NAME VENDOR_NAME,
VEN.EXTERNAL_ORGANIZATION_CONTACT VENDOR_CONTACT,
VEN.EXTERNAL_ORGANIZATION_EMAIL_AD VENDOR_EMAIL,
VEN.EXTERNAL_ORGANIZATION_PHONE VENDOR_PHONE,
LP.PHASE_TYPE PHASE_TYPE
FROM STANDARDS_CATEGORY SC
JOIN (
SELECT STANDARDS_CATEGORY_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID, HARDWARE_PRODUCT_COMPONENT_ID, MANUFACTURER_COMPONENT_ID, STEWARD_COMPONENT_ID, VENDOR_COMPONENT_ID, PHASE_COMPONENT_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY STANDARDS_CATEGORY_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID, HARDWARE_PRODUCT_COMPONENT_ID, MANUFACTURER_COMPONENT_ID, STEWARD_COMPONENT_ID, VENDOR_COMPONENT_ID, PHASE_COMPONENT_ID
) FACT ON FACT.STANDARDS_CATEGORY_COMP_ID = SC.STANDARDS_CATEGORY_ID
JOIN HARDWARE_PRODUCT_MODEL VER ON FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = VER.HARDWARE_PRODUCT_MODEL_ID
LEFT JOIN HARDWARE_PRODUCT ITP ON FACT.HARDWARE_PRODUCT_COMPONENT_ID = ITP.HARDWARE_PRODUCT_COMPONENT_ID
LEFT JOIN EXTERNAL_ORGANIZATION MAN ON FACT.MANUFACTURER_COMPONENT_ID = MAN.EXTERNAL_ORG_COMP_ID
LEFT JOIN PERSON P ON FACT.STEWARD_COMPONENT_ID = P.PERSON_COMPONENT_ID
LEFT JOIN EXTERNAL_ORGANIZATION VEN ON FACT.VENDOR_COMPONENT_ID = VEN.EXTERNAL_ORG_COMP_ID
LEFT JOIN (
SELECT LP.PHASE_COMPONENT_ID, LP.PHASE_TYPE, LP.PHASE_START_DATE, LP.PHASE_END_DATE
FROM LIFECYCLE_PHASE LP
JOIN DM_ENUMLIFECYCLE_TYPE LT ON LP.LIFECYCLE_TYPE_ID = LT.TROUXENUMERATIONVALUEID
WHERE LT.UUID = 'PropTypeValue_StandardsLifecycleType_Internal_for_Hardware_Product_Model_UUID'
) LP ON FACT.PHASE_COMPONENT_ID = LP.PHASE_COMPONENT_ID
WHERE
FACT.PHASE_COMPONENT_ID IS NULL
OR (
LP.PHASE_START_DATE <= {fn dbDate}
AND (LP.PHASE_END_DATE IS NULL OR LP.PHASE_END_DATE >= {fn dbDate})
)
ORDER BY CAT_NAME, PRODUCT_NAME, VERSION_NAME]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Prompt Categories Data Set" id="928">
<list-property name="columnHints">
<structure>
<property name="columnName">STANDARDS_CATEGORY_ID</property>
<text-property name="displayName">STANDARDS_CATEGORY_ID</text-property>
</structure>
<structure>
<property name="columnName">STANDARDS_CATEGORY_NAME</property>
<text-property name="displayName">STANDARDS_CATEGORY_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">BlueprintID</property>
<property name="paramName">BlueprintID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STANDARDS_CATEGORY_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">STANDARDS_CATEGORY_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">STANDARDS_CATEGORY_ID</property>
<property name="nativeName">STANDARDS_CATEGORY_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">STANDARDS_CATEGORY_NAME</property>
<property name="nativeName">STANDARDS_CATEGORY_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
SC.STANDARDS_CATEGORY_ID,
SC.STANDARDS_CATEGORY_NAME
FROM STANDARDS_CATEGORY SC
JOIN STANDARDS_FACT_HARDWARE FACT
ON SC.STANDARDS_CATEGORY_ID = FACT.STANDARDS_CATEGORY_COMP_ID
WHERE SC.STANDARDS_CAT_BLUEPRINT_ID = ?
AND FACT.HARDWARE_PRODUCT_MODEL_COMP_ID IS NOT NULL
GROUP BY SC.STANDARDS_CATEGORY_NAME, SC.STANDARDS_CATEGORY_ID
ORDER BY SC.STANDARDS_CATEGORY_NAME]]></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>STANDARDS_CATEGORY_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STANDARDS_CATEGORY_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STANDARDS_CATEGORY_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STANDARDS_CATEGORY_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STANDARDS_CATEGORY_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STANDARDS_CATEGORY_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Org Scope Data Set" id="930">
<list-property name="columnHints">
<structure>
<property name="columnName">ORG_SCOPE_ID</property>
<text-property name="displayName">ORG_SCOPE_ID</text-property>
</structure>
<structure>
<property name="columnName">ORG_SCOPE_NAME</property>
<text-property name="displayName">ORG_SCOPE_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORG_SCOPE_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORG_SCOPE_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ORG_SCOPE_ID</property>
<property name="nativeName">ORG_SCOPE_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ORG_SCOPE_NAME</property>
<property name="nativeName">ORG_SCOPE_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
ORG.INTERNAL_ORG_COMP_ID ORG_SCOPE_ID,
ORG.INTERNAL_ORG_COMP_NAME ORG_SCOPE_NAME
FROM INTERNAL_ORGANIZATION ORG
JOIN (
SELECT ORGANIZATION_SCOPE_COMPONENT_I, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY ORGANIZATION_SCOPE_COMPONENT_I, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.ORGANIZATION_SCOPE_COMPONENT_I = ORG.INTERNAL_ORG_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY ORG_SCOPE_NAME]]></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>ORG_SCOPE_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ORG_SCOPE_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORG_SCOPE_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ORG_SCOPE_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ORG_SCOPE_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ORG_SCOPE_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="BizFxns Data Set" id="947">
<list-property name="columnHints">
<structure>
<property name="columnName">BF_ID</property>
<text-property name="displayName">BF_ID</text-property>
</structure>
<structure>
<property name="columnName">BF_NAME</property>
<text-property name="displayName">BF_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BF_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">BF_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BF_ID</property>
<property name="nativeName">BF_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">BF_NAME</property>
<property name="nativeName">BF_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
BF.BUSINESS_FUNCTION_COMP_ID BF_ID,
BF.BUSINESS_FUNCTION_COMP_NAME BF_NAME
FROM BUSINESS_FUNCTION BF
JOIN (
SELECT BUSINESS_FUNCTION_COMPONENT_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY BUSINESS_FUNCTION_COMPONENT_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.BUSINESS_FUNCTION_COMPONENT_ID = BF.BUSINESS_FUNCTION_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY BF_NAME]]></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>BF_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>BF_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BF_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BF_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>BF_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BF_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Industry Standards Data Set" id="964">
<list-property name="columnHints">
<structure>
<property name="columnName">ISV_ID</property>
<text-property name="displayName">ISV_ID</text-property>
</structure>
<structure>
<property name="columnName">ISV_NAME</property>
<text-property name="displayName">ISV_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ISV_ID</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ISV_NAME</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ISV_ID</property>
<property name="nativeName">ISV_ID</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ISV_NAME</property>
<property name="nativeName">ISV_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
ISV.INDUSTRY_STANDARD_VER_COMP_ID ISV_ID,
ISV.INDUSTRY_STANDARD_VER_COM_NAME ISV_NAME
FROM INDUSTRY_STANDARD_VERSION ISV
JOIN (
SELECT INDUSTRY_STANDARD_VER_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
FROM STANDARDS_FACT_HARDWARE
GROUP BY INDUSTRY_STANDARD_VER_COMP_ID, HARDWARE_PRODUCT_MODEL_COMP_ID
) FACT ON FACT.INDUSTRY_STANDARD_VER_COMP_ID = ISV.INDUSTRY_STANDARD_VER_COMP_ID
WHERE FACT.HARDWARE_PRODUCT_MODEL_COMP_ID = ?
ORDER BY ISV_NAME]]></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>ISV_ID</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>28</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ISV_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ISV_ID</design:label>
<design:formattingHints>
<design:displaySize>30</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ISV_NAME</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ISV_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ISV_NAME</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Related Artifacts Data Set" id="981">
<list-property name="columnHints">
<structure>
<property name="columnName">LINK_TEXT</property>
<text-property name="displayName">LINK_TEXT</text-property>
</structure>
<structure>
<property name="columnName">LINK_URL</property>
<text-property name="displayName">LINK_URL</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">VersionID</property>
<property name="dataType">decimal</property>
<property name="position">1</property>
<expression name="defaultValue">0</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">LINK_TEXT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LINK_URL</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Troux Datamart</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">LINK_TEXT</property>
<property name="nativeName">LINK_TEXT</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LINK_URL</property>
<property name="nativeName">LINK_URL</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
HARDWARE_PRODUCT_MODEL_RELATE1 LINK_TEXT,
HARDWARE_PRODUCT_MODEL_RELATED LINK_URL
FROM HARDWARE_PRODUCT_MODEL_HARDWAR
WHERE HARDWARE_PRODUCT_MODEL_ID = ?
ORDER BY HARDWARE_PRODUCT_MODEL_LIST_IN]]></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>SOFTWARE_PRODUCT_VER_RA_TEXT</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOFTWARE_PRODUCT_VER_RA_TEXT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOFTWARE_PRODUCT_VER_RA_TEXT</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SOFTWARE_PRODUCT_VER_RA_URL</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>255</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SOFTWARE_PRODUCT_VER_RA_URL</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SOFTWARE_PRODUCT_VER_RA_URL</design:label>
<design:formattingHints>
<design:displaySize>255</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
|
|
| | | | | | | | |
Goto Forum:
Current Time: Wed Jul 23 19:36:48 EDT 2025
Powered by FUDForum. Page generated in 0.05002 seconds
|