New records inserted whenever updated

neharao · ‎05-19-2017

Hi all,

I have a requirement where i need to populate 'Work Notes' on 'Change Request' form Affected CI's table. I am able to achieve this but i have a

problem i.e whenever i am trying to change 'State' field or do any changes on the form and save each time its creating the same set of Affected

CI's in the work notes.

Please see the below screen shot.

My code looks like below:

Business rule : Executes on 'Before' with 'Insert' and 'Update'

var look2=new GlideRecord('task_ci');

look2.addQuery('task',current.sys_id);

look2.query();

while (look2.next())

{

current.work_notes = look2.ci_item.getDisplayValue();

//look2.task = current.sys_id;

look2.update();

}

Kindly can anyone help me on this that it should not create the same record again and again each time i change something on form and update.

Thanks,

Neha

Pradeep Sharma · ‎05-19-2017

Thanks for the details Neha.

You have to create an AFTER business rule on task_ci table with insert checkbox set to true and with filter condition as task starts with CHG.

This means the BR will be triggered only for change request records and with script as.

(function executeRule(current, previous /*null when async*/) {


   // Add your code here

   var gr = new GlideRecord('change_request');

   gr.addQuery('sys_id', current.task);

   gr.query();

   if(gr.next())

   {

   gr.work_notes = current.ci_item.getDisplayValue();

   gr.update();

   }


})(current, previous);

Please let me know if you have any questions.

View solution in original post

neharao · ‎05-19-2017

Hi Pradeep,

Yes it is triggering everytime i make any changes on the Change Request form. Please find the screen shot below. I cant put any particular condition because whenever i change anything on Change Request form it creating new record in Work Notes. Kindly guide me on this.

Thanks,

Neha

Pradeep Sharma · ‎05-19-2017

Thanks for the details Neha. I mean the business rule is working as expected. You will have to put some unique condition per your req to stop it from triggering.

neharao · ‎05-19-2017

Hi Pradeep,

Please find below the screen shot of the condition business rule.

Pradeep Sharma · ‎05-19-2017

Can you please give more details on where is the business rule defined and what is the exact requirement?

ryadavalli · ‎05-23-2017

I have a similar question, if an incident is created from external system through transform map, the after business rule which on insert/update triggers 2 times,

is it normal ?