Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
WSO2EI DataSource for IFS Database
<data name="IFSAPP9PROD" serviceNamespace="IFS" transports="http https local">
<description>IFS App9 Production</description>
<config enableOData="false" id="IFSAPP9PROD">
<property name="driverClassName">oracle.jdbc.driver.OracleDriver</property>
<property name="url">jdbc:oracle:thin:@<DBHOST>:1521:<SID></property>
<property name="username"><APPOWNER></property>
<property name="password"><APPOWNER_PW></property>
</config>
<query id="SELECT_ALL_WO_QUERY" useConfig="IFSAPP9PROD">
<sql>select CONTRACT, ORG_CODE, MCH_CODE, MCH_CODE_DESCRIPTION, MCH_CODE_CONTRACT, WO_NO, REG_DATE, ERR_DESCR, PLAN_S_DATE, REPORTED_BY, PART_NO, STATE from ACTIVE_SEPARATE</sql>
<result element="WOCollection" rowName="WORKORDER">
<element column="CONTRACT" name="CONTRACT" xsdType="xs:string"/>
<element column="ORG_CODE" name="ORG_CODE" xsdType="xs:string"/>
<element column="MCH_CODE" name="MCH_CODE" xsdType="xs:string"/>
<element column="MCH_CODE_DESCRIPTION" name="MCH_CODE_DESCRIPTION" xsdType="xs:string"/>
<element column="MCH_CODE_CONTRACT" name="MCH_CODE_CONTRACT" xsdType="xs:string"/>
<element column="REG_DATE" name="REG_DATE" xsdType="xs:date"/>
<element column="ERR_DESCR" name="ERR_DESCR" xsdType="xs:string"/>
<element column="PLAN_S_DATE" name="PLAN_S_DATE" xsdType="xs:date"/>
<element column="REPORTED_BY" name="REPORTED_BY" xsdType="xs:string"/>
<element column="PART_NO" name="PART_NO" xsdType="xs:string"/>
<element column="STATE" name="STATE" xsdType="xs:string"/>
</result>
</query>
<query id="SELECT_WO_BY_STATE_QUERY" useConfig="IFSAPP9PROD">
<sql>select CONTRACT, ORG_CODE, MCH_CODE, MCH_CODE_DESCRIPTION, MCH_CODE_CONTRACT, WO_NO, REG_DATE, ERR_DESCR, PLAN_S_DATE, REPORTED_BY, PART_NO, STATE from ACTIVE_SEPARATE WHERE STATE=?</sql>
<result element="WOCollection" rowName="WORKORDER">
<element column="CONTRACT" name="CONTRACT" xsdType="xs:string"/>
<element column="ORG_CODE" name="ORG_CODE" xsdType="xs:string"/>
<element column="MCH_CODE" name="MCH_CODE" xsdType="xs:string"/>
<element column="MCH_CODE_DESCRIPTION" name="MCH_CODE_DESCRIPTION" xsdType="xs:string"/>
<element column="MCH_CODE_CONTRACT" name="MCH_CODE_CONTRACT" xsdType="xs:string"/>
<element column="REG_DATE" name="REG_DATE" xsdType="xs:date"/>
<element column="ERR_DESCR" name="ERR_DESCR" xsdType="xs:string"/>
<element column="PLAN_S_DATE" name="PLAN_S_DATE" xsdType="xs:date"/>
<element column="REPORTED_BY" name="REPORTED_BY" xsdType="xs:string"/>
<element column="PART_NO" name="PART_NO" xsdType="xs:string"/>
<element column="STATE" name="STATE" xsdType="xs:string"/>
</result>
<param name="STATE" sqlType="STRING"/>
</query>
<operation name="SELECT_ALL_WO_QUERY_OPERATION">
<call-query href="SELECT_ALL_WO_QUERY"/>
</operation>
<operation name="SELECT_WO_BY_STATE_OPERATION">
<call-query href="SELECT_WO_BY_STATE_QUERY">
<with-param name="STATE" query-param="STATE"/>
</call-query>
</operation>
</data>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.