Insert Business Rule is not working on Certification task(cert_task) table

[pwr227]

I have created new Business rule  which is Before Insert to populate the Business Application field in cert_task table  and it is working when I'm checking the update check box and If I update any thing on cert_task but it is not working when the new cert_task is inserted.
The new cert task is getting inserted by Certification Schedule(cert_schedule) when we exectue this the new cer_task is getting created.
Can any please help me with this I need to populate the business application field on cert_task table, Please find the attached images of BR and cert_task Record.

 

[Anubhav24]

Hi @pwr227 ,

Can you put a info message inside your if to see if the control is going there and secondly is the column name correct where you have mentioned "certelement.id.sys_id", is there a column named "id" or you are just trying to insert the sys_id in that case it would be certelement.sys_id.

Please mark correct/helpful if my response helped you.

[Jonathan Schnei]

Can you revisit your requirement for this? I'm asking as I don't understand why you would do this for the following reasons:

1. The Business Application is also referenced in the line item (covered in red in your screenshot should be a hyperlink name for the BA) and a user can just click through that to get to the Business App - so the reference field is redundant.

2. Certification tasks can be assigned to multiple Business Apps - in that case, which would you select for this field and what about the other BA's in the task?

3. Most importantly, Data Certification is being deprecated. They are recommending you migrate existing schedules to Data Policies in the CMDB workspace.

[pwr227]

Hello Jonathan, 

Thank you for your response!

When the Schedule gets Executed it will create multiple Tasks as per my Filters (Cert_filter) in filter I have given Business application number is APM**** or  Number is APM*** so on,

Each task consist one reference Business application but as we only have one field on cert_task table  which is "Business Application" and this field also comes as empty when the task gets created,

My scenario is like when the task gets created it should assign to IT Owner that is done by Cert Schedule as we can set their assign to for Cert Tasks and as the IT Owner Certifies all the fields of business app and as the percentage completes to 100 task goes to closed to closed complete that time I'm triggering one Flow which triggers on Cert_task table and when the Schedule is the one which we runs and state changes to close complete and percent changes to 100 and after this I need to trigger approval from Business Owner of Business app so in  this case I need the Business application field to be filled with the specific business application of task because then only I can dot walk to business owner field

so that's why I'm setting that field through Business Rule as when the cert_task inserted 

Hope you will get my requirement..

Thanks in advance.