Eclipse Community Forums: BIRT » How to pass parameters in list?

Home » Archived » BIRT » How to pass parameters in list?

How to pass parameters in list? [message #261316]

Tue, 13 November 2007 07:23

Eclipse User

Hi, all.
I want to pass parameters in a simple query like this:
select *
from mytable
where mypar in (?)
How do one do this in BIRT?

Thanks in advance?

Re: How to pass parameters in list? [message #261361 is a reply to message #261316]

Wed, 14 November 2007 00:41

Eclipse User

I create a report, hope it is helpful.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.3.0.v20071108 Build <2.3.0.v20071112-0800></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company Name
here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<parameters>
<scalar-parameter name="param_1" id="79">
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<property name="isRequired">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">OFFICES</property>
<expression
name="valueExpr">dataSetRow["OFFICECODE"]</expression>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</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="Data Source"
id="6">
<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="7">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICECODE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">param_1</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<expression
name="defaultValue">params["p2"]</expression>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<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">OFFICECODE</property>
<property name="nativeName">OFFICECODE</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="queryText">select OFFICECODE
from offices
where OFFICECODE in (?)</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:DataSetParameters>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</design:optional>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
</design:DataSetParameters>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="OFFICES" id="67">
<list-property name="columnHints">
<structure>
<property name="columnName">OFFICECODE</property>
<property name="displayName">OFFICECODE</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICECODE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">OFFICECODE</property>
<property name="nativeName">OFFICECODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select OFFICECODE
from offices</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2"/>
</page-setup>
<body>
<table id="81">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">OFFICECODE</property>
<expression
name="expression">dataSetRow["OFFICECODE"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="90"/>
<header>
<row id="82">
<cell id="83">
<label id="84">
<text-property
name="text">OFFICECODE</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="85">
<cell id="86">
<data id="87">
<property
name="resultSetColumn">OFFICECODE</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="88">
<cell id="89"/>
</row>
</footer>
</table>
</body>
</report>

Re: How to pass parameters in list? [message #261603 is a reply to message #261361]

Sat, 17 November 2007 17:56

Eclipse User

Originally posted by: ibmer.mail.ru

Thanks! That will work definitelly!

Previous Topic:	crosstab - dynamically hide dimension levels
Next Topic:	GWT with birt

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jun 06 07:07:21 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter