|
|
|
## 用途
|
|
|
|
本頁針對舊版 cloud report 唔會處理𠿬 updatePayment,導致錯數嘅問題
|
|
|
|
|
|
|
|
## 處理方法
|
|
|
|
1. 首先用 SQL 以日子 filter 返 shop server 入面嘅 tender payment archive,如圖
|
|
|
|
![image](uploads/d49e770dee767f2378b0ebb61c0e7208/image.png)
|
|
|
|
[SQL Statement](http://gitlab.web-on.com/-/snippets/38)
|
|
|
|
|
|
|
|
2. 當你成功係上一點搵到取消咗嘅付款方法,除咗付款方法嘅 data,另外仲會 gen 多一條 string,係俾你之後係 cloud data filter 用,如圖
|
|
|
|
![image](uploads/49150f007b4261b3978b3c0e1def3bb9/image.png)
|
|
|
|
|
|
|
|
3. 之後用 SQL Management Studio execute 上圖嘅 filter 用嘅 SQL Statement,你會得到以下嘅結果
|
|
|
|
![image](uploads/3ff93f32a799a61f476399d15c16c17d/image.png)
|
|
|
|
|
|
|
|
4. 呢啲 data 已經無用途,可以一口氣 delete
|
|
|
|
![image](uploads/b89f646875566843e24575fec210df6a/image.png)
|
|
|
|
|
|
|
|
5. 最後,將 local data 透過 copy and paste 放入 cloud database
|
|
|
|
![image](uploads/1d63b722198d5f02913e5028037d298d/image.png) |
|
|
|
\ No newline at end of file |