Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
1 Beantwoorden
1024 Weergaven
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
Annuleer
Kaushik Pathak

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

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Beste antwoord

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