I tried to update qty_done for a purchase order with with @route
Here is my code:
@route('/api/purchase_order2/', type='http', auth='none', methods=['PUT'], csrf=False)
def update_purchase_order(self, purchase_order_id, **kwargs):
purchase_order_id = int(purchase_order_id)
# Get purchase order
purchase_order = request.env['purchase.order'].sudo().search([('id', '=', purchase_order_id)])
picking = purchase_order.picking_ids[0]
picking.move_line_ids.write({'qty_done': 1})
res_dict = picking.button_validate()
# print('res_dict', res_dict)
data = json.loads(request.httprequest.data)
headers = {'Content-Type': 'application/json'}
return Response(json.dumps({'data': 'success'}), headers=headers)
I got the following error message when i call the api
`2023-05-03 14:02:06,067 2124917 ERROR dev_db odoo.sql_db: bad query:
SELECT fol.id, fol.res_id, fol.partner_id, array_agg(subtype.id)
FROM mail_followers fol
LEFT JOIN mail_followers_mail_message_subtype_rel fol_rel ON fol_rel.mail_followers_id = fol.id
LEFT JOIN mail_message_subtype subtype ON subtype.id = fol_rel.mail_message_subtype_id
WHERE fol.res_model = 'stock.picking' AND fol.res_id IN (1)AND (fol.partner_id IN (false))
GROUP BY fol.id
ERROR: operator does not exist: integer = boolean
LINE 7: ...picking' AND fol.res_id IN (1)AND (fol.partner_id IN (false)...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.`
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客戶關係
- e-Commerce
- 會計
- 庫存
- PoS
- Project
- MRP
此問題已被標幟
1
回覆
2003
瀏覽次數
Hi,
SELECT fol.id, fol.res_id, fol.partner_id, array_agg(subtype.id)FROM mail_followers fol
LEFT JOIN mail_followers_mail_message_subtype_rel fol_rel ON fol_rel.mail_followers_id = fol.id
LEFT JOIN mail_message_subtype subtype ON subtype.id = fol_rel.mail_message_subtype_id
WHERE fol.res_model = 'stock.picking' AND fol.res_id IN (1) AND (fol.partner_id IS NOT NULL)
GROUP BY fol.id
Hope it helps
相關帖文 | 回覆 | 瀏覽次數 | 活動 | |
---|---|---|---|---|
|
0
3月 24
|
1256 | ||
|
3
2月 24
|
2860 | ||
|
1
5月 23
|
2405 | ||
|
0
12月 23
|
2048 | ||
|
0
1月 24
|
1393 |