Created
May 21, 2015 15:34
-
-
Save exlcodeshare/0b3d32b075b5b6459d8c to your computer and use it in GitHub Desktop.
Rosetta - BIRT Report of IEs viewed over last 30 days
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16" id="1"> | |
<property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630></property> | |
<property name="units">in</property> | |
<property name="iconFile">/templates/blank_report.gif</property> | |
<simple-property-list name="includeResource"> | |
<value>DPSreports</value> | |
</simple-property-list> | |
<html-property name="description">Provides instructions for building a customer listing report.</html-property> | |
<method name="initialize"> | |
<![CDATA[importPackage(Packages.com.exlibris.core.infra.common.security); | |
if (UserPrincipalRetriever.getInstitutionPathNoException() !=null){ | |
params["inst"] = UserPrincipalRetriever.getInstitutionPathNoException(); | |
}else { | |
params["inst"] = '%'; | |
}]]> | |
</method> | |
<property name="theme">dpslib.defaultTheme</property> | |
<text-property name="displayName">IEs viewed over last 30 days</text-property> | |
<list-property name="libraries"> | |
<structure> | |
<property name="fileName">dpslib.rptlibrary</property> | |
<property name="namespace">dpslib</property> | |
</structure> | |
</list-property> | |
<parameters> | |
<scalar-parameter name="inst" id="8"> | |
<property name="hidden">true</property> | |
<property name="valueType">static</property> | |
<property name="dataType">string</property> | |
<property name="paramType">simple</property> | |
<property name="concealValue">true</property> | |
<property name="isRequired">false</property> | |
<property name="controlType">text-box</property> | |
<property name="distinct">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="Reporting_Schema" id="6" | |
extends="dpslib.Reporting_Schema"/> | |
</data-sources> | |
<data-sets> | |
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ies_viewed_30_days" id="7"> | |
<structure name="cachedMetaData"> | |
<list-property name="resultSet"> | |
<structure> | |
<property name="position">1</property> | |
<property name="name">NUMBER_OF_VIEWS</property> | |
<property name="dataType">decimal</property> | |
</structure> | |
<structure> | |
<property name="position">2</property> | |
<property name="name">IE_PID</property> | |
<property name="dataType">string</property> | |
</structure> | |
</list-property> | |
</structure> | |
<property name="dataSource">Reporting_Schema</property> | |
<list-property name="parameters"> | |
<structure> | |
<property name="name">param_1</property> | |
<property name="paramName">inst</property> | |
<property name="dataType">string</property> | |
<property name="position">1</property> | |
<property name="isInput">true</property> | |
<property name="isOutput">false</property> | |
</structure> | |
<structure> | |
<property name="name">param_2</property> | |
<property name="dataType">string</property> | |
<property name="position">2</property> | |
<expression name="defaultValue">if (params !=null && params["inst"] !=null && params["inst"].value != null) {BirtStr.concat(params["inst"].value,'.%');} | |
else {'%';}</expression> | |
<property name="isInput">true</property> | |
<property name="isOutput">false</property> | |
</structure> | |
</list-property> | |
<list-property name="resultSet"> | |
<structure> | |
<property name="position">1</property> | |
<property name="name">NUMBER_OF_VIEWS</property> | |
<property name="nativeName">NUMBER_OF_VIEWS</property> | |
<property name="dataType">decimal</property> | |
</structure> | |
<structure> | |
<property name="position">2</property> | |
<property name="name">IE_PID</property> | |
<property name="nativeName">IE_PID</property> | |
<property name="dataType">string</property> | |
</structure> | |
</list-property> | |
<property name="queryText">SELECT count(EVENT_ID_NUMBER) AS "NUMBER_OF_VIEWS", value as "IE_PID" | |
FROM events e, event_keys k, hdecontrol_view v | |
WHERE e.event_date BETWEEN TRUNC(SYSDATE) -130 AND TRUNC(SYSDATE) AND e.EVENT_ID_NUMBER = k.event_id AND e.event_type = 160 and v.pid = k.value and (v.owner = ? or v.owner like ?) | |
GROUP BY value ORDER BY number_of_views DESC</property> | |
</oda-data-set> | |
</data-sets> | |
<styles> | |
<style name="crosstab" id="4"> | |
<property name="borderBottomColor">#CCCCCC</property> | |
<property name="borderBottomStyle">solid</property> | |
<property name="borderBottomWidth">1pt</property> | |
<property name="borderLeftColor">#CCCCCC</property> | |
<property name="borderLeftStyle">solid</property> | |
<property name="borderLeftWidth">1pt</property> | |
<property name="borderRightColor">#CCCCCC</property> | |
<property name="borderRightStyle">solid</property> | |
<property name="borderRightWidth">1pt</property> | |
<property name="borderTopColor">#CCCCCC</property> | |
<property name="borderTopStyle">solid</property> | |
<property name="borderTopWidth">1pt</property> | |
</style> | |
<style name="crosstab-cell" id="5"> | |
<property name="borderBottomColor">#CCCCCC</property> | |
<property name="borderBottomStyle">solid</property> | |
<property name="borderBottomWidth">1pt</property> | |
<property name="borderLeftColor">#CCCCCC</property> | |
<property name="borderLeftStyle">solid</property> | |
<property name="borderLeftWidth">1pt</property> | |
<property name="borderRightColor">#CCCCCC</property> | |
<property name="borderRightStyle">solid</property> | |
<property name="borderRightWidth">1pt</property> | |
<property name="borderTopColor">#CCCCCC</property> | |
<property name="borderTopStyle">solid</property> | |
<property name="borderTopWidth">1pt</property> | |
</style> | |
</styles> | |
<page-setup> | |
<simple-master-page name="Simple MasterPage" id="2"> | |
<page-footer> | |
<text id="3"> | |
<property name="contentType">html</property> | |
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> | |
</text> | |
</page-footer> | |
</simple-master-page> | |
</page-setup> | |
<body> | |
<table id="9"> | |
<property name="height">0.9479166666666666in</property> | |
<property name="width">2.3125in</property> | |
<property name="dataSet">ies_viewed_30_days</property> | |
<list-property name="boundDataColumns"> | |
<structure> | |
<property name="name">NUMBER_OF_VIEWS</property> | |
<expression name="expression">dataSetRow["NUMBER_OF_VIEWS"]</expression> | |
<property name="dataType">decimal</property> | |
</structure> | |
<structure> | |
<property name="name">IE_PID</property> | |
<expression name="expression">dataSetRow["IE_PID"]</expression> | |
<property name="dataType">string</property> | |
</structure> | |
<structure> | |
<property name="name">Column Binding</property> | |
<property name="displayName">Total</property> | |
<expression name="expression">Total.sum(row["NUMBER_OF_VIEWS"])</expression> | |
<property name="dataType">integer</property> | |
</structure> | |
</list-property> | |
<column id="19"> | |
<property name="width">0.6458333333333334in</property> | |
</column> | |
<column id="20"> | |
<property name="width">1.7708333333333333in</property> | |
</column> | |
<header> | |
<row id="10"> | |
<cell id="11"> | |
<label id="23"> | |
<text-property name="text">IE_PID</text-property> | |
</label> | |
</cell> | |
<cell id="12"> | |
<label id="21"> | |
<text-property name="text">NUMBER_OF_VIEWS</text-property> | |
</label> | |
</cell> | |
</row> | |
</header> | |
<detail> | |
<row id="13"> | |
<cell id="14"> | |
<data id="24"> | |
<property name="resultSetColumn">IE_PID</property> | |
</data> | |
</cell> | |
<cell id="15"> | |
<data id="22"> | |
<property name="resultSetColumn">NUMBER_OF_VIEWS</property> | |
</data> | |
</cell> | |
</row> | |
</detail> | |
<footer> | |
<row id="69"> | |
<cell id="70"> | |
<text id="84"> | |
<property name="contentType">auto</property> | |
<text-property name="content"><![CDATA[Total:]]></text-property> | |
</text> | |
</cell> | |
<cell id="71"> | |
<data id="83"> | |
<property name="resultSetColumn">Column Binding</property> | |
</data> | |
</cell> | |
</row> | |
</footer> | |
</table> | |
</body> | |
</report> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment