Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
1 Odpowiedz
1025 Widoki
Awatar
Pete Charalampopoulos

Hi Everyone

i have a scheduled action that should run and update some fields.


recordset = env['stock.move.line'].search(['&', ('x_studio_sales_order', '=', False), ('reference', 'ilike', 'WH1/IN/'), ('x_studio_related_field_rnnjz', '!=', False), ('x_studio_date_of_transfer', '=', datetime.datetime.now())])


for record in recordset:

    record.write({

        'x_studio_received_under_sale_order': record.x_studio_related_field_rnnjz.name,

        'x_studio_sales_order': record.x_studio_related_field_rnnjz.id

    })



i get no errors, it runs but the fields do not get updated

Do you think there is something wrong in the domain?

Awatar
Odrzuć
Kaushik Pathak

I think no need to write '&' in search mechanism or you can check Odoo default.

Awatar
Cybrosys Techno Solutions Pvt.Ltd
Najlepsza odpowiedź

Hi,Couldn't find Issue in your code, but here might be a few potential ways to check:
Logging or Debugging: Add logging statements or print statements within your loop to check if the loop is being entered and if the records are being fetched as expected.

Error Handling: Wrap your loop in a try-except block to catch any potential errors that might occur during the write operation. This can help identify any issues that might be causing the write operation to fail silently.

Check Domain:  Ensure that your search domain is correctly filtering the records you intend to update
Hope this helps


Hope it helps

Awatar
Odrzuć
Pete Charalampopoulos
Autor

here is the issue, when i set a >= date in the code then ir runs

recordset = env['stock.move.line'].search([('x_studio_sales_order', '=', False), ('reference', 'ilike', 'WH1/IN/'), ('x_studio_related_field_rnnjz', '!=', False), ('x_studio_date_of_transfer', '>=', '2024-02-01 00:00:00')])

for record in recordset:
record.write({
'x_studio_received_under_sale_order': record.picking_id.sale_id.name,
'x_studio_sales_order': record.picking_id.sale_id.id
})