diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-08-23 16:43:30 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-08-23 16:43:30 +0700 |
| commit | 644d994308d095e36c41dbf9f9834abbdecf49fe (patch) | |
| tree | 4ad3a89d34cbd45d74e3c27e1323f71623c5c056 /update_count_trx_po_vendor.ktr | |
| parent | 1babee964cab4f789488fe5b17b3db22b25dc80e (diff) | |
remove interval 365 days
Diffstat (limited to 'update_count_trx_po_vendor.ktr')
| -rw-r--r-- | update_count_trx_po_vendor.ktr | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/update_count_trx_po_vendor.ktr b/update_count_trx_po_vendor.ktr index 9191fea..ab116d9 100644 --- a/update_count_trx_po_vendor.ktr +++ b/update_count_trx_po_vendor.ktr @@ -430,7 +430,7 @@ <created_date>2023/08/21 13:18:06.915</created_date> <modified_user>-</modified_user> <modified_date>2023/08/21 13:18:06.915</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -549,7 +549,7 @@ </partitioning> <connection>dw bi indoteknik</connection> <sql>select pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod -where pod.state = 'done' and pod.po_date >= (now() - '365 days'::interval) +where pod.state = 'done' group by pod.partner_id</sql> <limit>0</limit> <lookup/> |