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

Alikutty A · ‎05-19-2017

Hi Neha,

Have you specified any condition on your business rule. If the condition is State is "value", can you correct it to State changes to "value"?

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

Alikutty A · ‎05-19-2017

Your condition on the business rule should be Work notes changes.

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

neharao · ‎05-19-2017

Hi Alikutty,

Thanks for your reply. My requirement is whenever i change anything on form and save it should not create new records in work notes. So i cannot add any specific condition in the business rule. Could you please suggest me how to proceed on this.

Also if i keep only 'Insert' option in Business rule it is not even populating Work Notes.

Thanks,

Neha

Ujjawal Vishnoi · ‎05-19-2017

Hi Neha,

My understanding is below.

You want to populate 'Work Notes' on 'Change Request' form Affected CI's whenever you make changes to task_ci record.

If this is the case then create BR on task_ci table and glide on chage_request and update the work_notes.

Hop this helps.

Regards

Ujjawal