diff options
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 48 | ||||
| -rw-r--r-- | import_purchase_order_v2.ktr | 6 |
2 files changed, 52 insertions, 2 deletions
diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index 727683d..13dd3fc 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -1541,6 +1541,45 @@ <yloc>528</yloc> <attributes_kjc/> </entry> + <entry> + <name>purchase order v2</name> + <description/> + <type>TRANS</type> + <attributes/> + <specification_method>filename</specification_method> + <trans_object_id/> + <filename>/home/stephan/transformation-job-bi/import_purchase_order_v2.ktr</filename> + <transname/> + <arg_from_previous>N</arg_from_previous> + <params_from_previous>N</params_from_previous> + <exec_per_row>N</exec_per_row> + <clear_rows>N</clear_rows> + <clear_files>N</clear_files> + <set_logfile>N</set_logfile> + <logfile/> + <logext/> + <add_date>N</add_date> + <add_time>N</add_time> + <loglevel>Basic</loglevel> + <cluster>N</cluster> + <slave_server_name/> + <set_append_logfile>N</set_append_logfile> + <wait_until_finished>Y</wait_until_finished> + <follow_abort_remote>N</follow_abort_remote> + <create_parent_folder>N</create_parent_folder> + <logging_remote_work>N</logging_remote_work> + <run_configuration>Pentaho local</run_configuration> + <suppress_result_data>N</suppress_result_data> + <parameters> + <pass_all_parameters>Y</pass_all_parameters> + </parameters> + <parallel>N</parallel> + <draw>Y</draw> + <nr>0</nr> + <xloc>496</xloc> + <yloc>528</yloc> + <attributes_kjc/> + </entry> </entries> <hops> <hop> @@ -1831,6 +1870,15 @@ <evaluation>Y</evaluation> <unconditional>N</unconditional> </hop> + <hop> + <from>logbook sj</from> + <to>purchase order v2</to> + <from_nr>0</from_nr> + <to_nr>0</to_nr> + <enabled>Y</enabled> + <evaluation>Y</evaluation> + <unconditional>N</unconditional> + </hop> </hops> <notepads> </notepads> diff --git a/import_purchase_order_v2.ktr b/import_purchase_order_v2.ktr index b8edaf5..dd7c256 100644 --- a/import_purchase_order_v2.ktr +++ b/import_purchase_order_v2.ktr @@ -561,7 +561,8 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from purchase_order</sql> + <sql>select * from purchase_order po +where po.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1677,7 +1678,8 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from purchase_order_line</sql> + <sql>select * from purchase_order_line po +where po.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |