跳至内容
菜单
此问题已终结
2 回复
1475 查看

I am setting a todo in Sales and when todo is overdue I like to trigger a rule. 


Apply on is set to "Activity State=Overdue" which is working because its shoving me number of records.

I have tried to set trigger on Save, and on UI change but haven't been able to trigger the rule.

What am I missing here? Any Ideas?

形象
丢弃
编写者 最佳答案

That is great info thanks for your time

形象
丢弃
最佳答案

Hi,



To trigger a rule when an activity becomes overdue, you should use a Scheduled Action instead of relying on "on-save" or "UI change" triggers. Scheduled actions run periodically. Go to Settings > Technical > Automation > Scheduled Actions and create a new scheduled action. Enter a name, set the model as 'Activity', and set how often you want it to run (e.g., every hour, daily). Specify when it should first run (Next Execution Date). You can also set the number of calls (Set -1 for unlimited calls.). Then add Python Code to Execute Your Desired Rule:


For example:



overdue_activities = env['mail.activity'].search([


    ('date_deadline', '<', datetime.date.today()),  # Check overdue


    ('state', '!=', 'done')


])


for activity in overdue_activities:


    # Your logic here


    # For example if you want to send a message to the assigned user (if applicable)


    if activity.user_id:


        env['mail.message'].create({


            'body': "Activity is overdue!",


            'subject': 'Overdue Activity Notification',


            'message_type': 'notification',


            'subtype_id': env.ref('mail.mt_comment').id,


            'partner_ids': [(4, activity.user_id.partner_id.id)],


            'res_id': activity.id,


            'model': 'mail.activity',


        })



    # Optionally, if you want to add a message to the related record's chatter


    if activity.res_id and activity.res_model:


        related_record = env[activity.res_model].browse(activity.res_id)


        try:


            related_record.message_post(


                body="The activity is overdue.",


                message_type='comment',


            )


        except AttributeError:


            pass


Hope it helps

形象
丢弃
相关帖文 回复 查看 活动
1
12月 24
1282
2
6月 24
2195
4
7月 24
3902
1
5月 23
3539
2
1月 21
3409