diff options
Diffstat (limited to 'refresh_materialized_view.ktr')
| -rw-r--r-- | refresh_materialized_view.ktr | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/refresh_materialized_view.ktr b/refresh_materialized_view.ktr index 8b21a1a..08742eb 100644 --- a/refresh_materialized_view.ktr +++ b/refresh_materialized_view.ktr @@ -509,12 +509,12 @@ </hop> <hop> <from>customer_current_year</from> - <to>Execute SQL script</to> + <to>update quarter</to> <enabled>Y</enabled> </hop> </order> <step> - <name>accurate</name> + <name>update quarter</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -529,7 +529,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_omzet_by_invoice_accurate</sql> + <sql>select update_running_quarter()</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -546,13 +546,13 @@ </output> </remotesteps> <GUI> - <xloc>240</xloc> + <xloc>1024</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>adempiere</name> + <name>accurate</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -567,7 +567,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_omzet_by_invoice_adempiere</sql> + <sql>refresh materialized view mv_omzet_by_invoice_accurate</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -584,13 +584,13 @@ </output> </remotesteps> <GUI> - <xloc>400</xloc> + <xloc>240</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>combine</name> + <name>adempiere</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -605,7 +605,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_omzet_by_invoice_combine</sql> + <sql>refresh materialized view mv_omzet_by_invoice_adempiere</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -622,13 +622,13 @@ </output> </remotesteps> <GUI> - <xloc>560</xloc> + <xloc>400</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>customer_current_year</name> + <name>combine</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -643,7 +643,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view dw_customer_current_year</sql> + <sql>refresh materialized view mv_omzet_by_invoice_combine</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -660,13 +660,13 @@ </output> </remotesteps> <GUI> - <xloc>880</xloc> + <xloc>560</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>salesperson</name> + <name>customer_current_year</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -681,7 +681,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view dw_salesperson</sql> + <sql>refresh materialized view dw_customer_current_year</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -698,13 +698,13 @@ </output> </remotesteps> <GUI> - <xloc>720</xloc> + <xloc>880</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Execute SQL script</name> + <name>salesperson</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -719,7 +719,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>select update_running_quarter()</sql> + <sql>refresh materialized view dw_salesperson</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -736,7 +736,7 @@ </output> </remotesteps> <GUI> - <xloc>1024</xloc> + <xloc>720</xloc> <yloc>160</yloc> <draw>Y</draw> </GUI> |