Posts

Showing posts from July, 2018
Example of Data Template <?xml version="1.0" encoding="UTF-8"?> <dataTemplate name="PER" description="EMPLOYEE_DESCRIPTION" defaultPackage="employee" version="1.0"> <parameters> </parameters> <dataQuery> <sqlStatement name="PER"> <![CDATA[Select PERSON_ID, EMPLOYEE_NUMBER,FULL_NAME,NATIONALITY,SEX,PARTY_ID from PER_ALL_PEOPLE_F where 1=1 AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND PERSON_ID IN (156, 461 ) AND ROWNUM<16]]> </sqlStatement> </dataQuery> <dataStructure>  <group name="PER" source="PER">  <element name="PERSON_ID" value="PERSON_ID"/>  <element name="EMPLOYEE_NUMBER" value="EMPLOYEE_NUMBER"/>  <element name="FULL_NAME" value="FULL_NAME"/>  <element name="NATIONALITY" value="NATIONALITY"/>