Skip to Content
This question has been flagged
2 Replies
1006 Views
Avatar
Pete Charalampopoulos

Hi all

i have a model that i create records based on an automated action. There is times that i see the same record twice the same day. Im sure there is a user error so im trying to make  a scheduled action to search today for duplicates and delete one of them

so i have a field called x_date_repaired

the field that is the actual name of the record x_name  

and a 3rd field that need to be set x_studio_serial_number


how can i make this happen in a scheduled action that runs every day?

im just looking help with the python code, im familiar with actions


thanks in advance  

Avatar
Discard
Avatar
Pete Charalampopoulos
Author Best Answer

Im adding the code in the scheduled action:

and when i click "run manually" to test it i get this error:

ValueError: : "name 'x_report' is not defined" while evaluating
"def delete_duplicate_records(self): records_to_delete = []\r\n    # Search for records with the same x_date_repaired on the same day\r\nduplicate_records = x_report.search([('x_date_repaired', '=', fields.Date.today())])\r\nseen_combinations = set()\r\nfor record in duplicate_records:\r\n combination = (record.x_name, record.x_studio_serial_number)\r\nif combination in seen_combinations:\r\n  records_to_delete.append(record.id)\r\nelse:\r\n  seen_combinations.add(combination)\r\n    # Delete the duplicate records\r\nx_report.browse(records_to_delete).unlink()"


Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,Please refer the below lines of code
you can create a scheduled action by using below code:


<odoo>
<record id="auto_delete_duplicate_record" model="ir.cron">
        <field name="name">Duplicate: Delete duplicate record</field>
<field name="interval_number">1</field>
<field name="interval_type">days</field>
        <field name="numbercall">-1</field>
        <field name="user_id" ref="base.user_root"/>
        <field name="doall" eval="False"/>
        <field name="model_id" ref="model_your_model"/>
<field name="code">model.delete_duplicate_records()</field>
        <field name="state">code</field>
    </record>

</odoo>


And write the Python code your function in your module python file:
def delete_duplicate_records(self):    records_to_delete = []
    # Search for records with the same x_date_repaired on the same day
    duplicate_records = YourModel.search([('x_date_repaired', '=', fields.Date.today())])
    seen_combinations = set()
    for record in duplicate_records:
        combination = (record.x_name, record.x_studio_serial_number)
        if combination in seen_combinations:
            records_to_delete.append(record.id)
        else:
            seen_combinations.add(combination)
    # Delete the duplicate records
    YourModel.browse(records_to_delete).unlink()
And you can also refer the below blog to know about more about scheduled action:https://www.cybrosys.com/blog/how-to-configure-schedule-actions-in-the-odoo-16


Hope it helps

Avatar
Discard