Se rendre au contenu
Cette question a été signalée
1 Répondre
1030 Vues
Avatar
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?

Avatar
Ignorer
Kaushik Pathak

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

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Meilleure réponse

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

Avatar
Ignorer
Pete Charalampopoulos
Auteur

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
})