任務牆 - 建立審核新增.md
24 additions, 9 deletions
| ... | ... | @@ -112,26 +112,41 @@ |
| 112 | - ### 條件設定 | |
| 112 | + ### 子條件設定 | |
| 113 | +**每一個 patterns array 內的條件為 "or"，每個 每個條件間的關聯為 "and"** | |
| 113 | 114 | { |
| 115 | + name: "500點以上票券", | |
| 116 | + patterns: | |
| 117 | + [ | |
| 118 | + { | |
| 114 | 119 | "field": "product_name", |
| 115 | 120 | "operator": "like", |
| 116 | 121 | "values": ["現金券", "抵用券"] |
| 117 | 122 | }, |
| 118 | 123 | { |
| 119 | 124 | "field": "point_limit", |
| 120 | - "operator": "gt", | |
| 125 | + "operator": "ge", | |
| 121 | 126 | "values": [500] |
| 122 | 127 | } |
| 128 | + ], | |
| 129 | + name: "指定品牌星巴巴", | |
| 130 | + patterns: | |
| 131 | + [ | |
| 132 | + { | |
| 133 | + "field": "brand_name", | |
| 134 | + "operator": "in", | |
| 135 | + "values": ["星巴克"] | |
| 136 | + }, | |
| 137 | + } | |
| 138 | +] | |
| 123 | -* 請參考 Table Schema ([https://app.clickup.com/3626232/docs/3en7r-19300/3en7r-123898](https://app.clickup.com/3626232/docs/3en7r-19300/3en7r-123898))下方說明 | |
| 124 | - * **欄位說明 ** | |
| 139 | + * **欄位說明 (**完整說明請參考 Table Schema ([https://app.clickup.com/3626232/docs/3en7r-19300/3en7r-123898](https://app.clickup.com/3626232/docs/3en7r-19300/3en7r-123898))) | |
| 125 | 140 | * **field：** |
| 126 | 141 | * serial_id 指定票券 |
| 127 | 142 | * brand_id 指定品牌 |
| 128 | 143 | * **operator：** |
| 129 | 144 | * in 完全相符 |
| 130 | 145 | * like 包含 |
| 131 | - * not_like (品牌關鍵字、品名關鍵字)，not_in (指定票券、指定品牌) 不包含 | |
| 132 | - * gt 大於 | |
| 133 | - * lt 小於 | |
| 134 | - * eq 等於 | |
| 135 | - * **value：**不論一或多個值，皆以陣列形式表示 | |
| 146 | + * not_like (品牌關鍵字、品名關鍵字) | |
| 147 | + * not_in (指定票券、指定品牌) 不包含 | |
| 148 | + * ge 大於等於 | |
| 149 | + * le 小於等於 | |
| 150 | + * **value：**不論一或多個值，皆以陣列形式表示 |