<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="ServiceExterne" id="804">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CLD_ROW_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ANN_ANNEE</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">SER_TYPE_SERVI</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SER_CLIENTELE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SER_ROW_ID</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">CLD</property>
<list-property name="parameters">
<structure>
<property name="name">param1</property>
<property name="paramName">cld_row_id</property>
<property name="nativeName"></property>
<property name="dataType">any</property>
<property name="nativeDataType">0</property>
<property name="position">1</property>
<property name="isOptional">false</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param2</property>
<property name="paramName">annee</property>
<property name="nativeName"></property>
<property name="dataType">any</property>
<property name="nativeDataType">0</property>
<property name="position">2</property>
<property name="isOptional">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">CLD_ROW_ID</property>
<property name="nativeName">CLD_ROW_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">ANN_ANNEE</property>
<property name="nativeName">ANN_ANNEE</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">SER_TYPE_SERVI</property>
<property name="nativeName">SER_TYPE_SERVI</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SER_CLIENTELE</property>
<property name="nativeName">SER_CLIENTELE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SER_ROW_ID</property>
<property name="nativeName">SER_ROW_ID</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<property name="queryText">SELECT SER.cld_row_id, SER.ann_annee,
SER.ser_type_servi, SER.ser_clientele,
SER.ser_row_id
FROM cld_servi_ext SER
WHERE SER.cld_row_id = ?
AND SER.ann_annee = ?
</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model
esignValues 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
ataSetParameters>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>1</design:position>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>Identifiant du CLD</design:displayName>
</design:uiHints>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>001</design:defaultScalarValue>
<design:optional>false</design:optional>
<design:masksValue>false</design:masksValue>
<design:uiHints>
<design:promptStyle>TextField</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nullability>Unknown</design:nullability>
<design:uiHints>
<design:displayName>Année de la saisie</design:displayName>
</design:uiHints>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>2007</design:defaultScalarValue>
<design:optional>true</design:optional>
<design:masksValue>false</design:masksValue>
<design:uiHints>
<design:promptStyle>TextField</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
</design
ataSetParameters>
</model
esignValues>]]></xml-property>
</oda-data-set>
Partager