save values from field to table

aastha3 · ‎10-13-2016

Hi ,

I am looking for a code to save 2 values in the Virtual Machine CI form (cmdb_ci_vm table). Form will have fields VMname1 , IPAddress1 Similarly VMname2 , IpAddress2 ,VMname3 IpAddress3 and have to save the data filled in these fields in a table similarly with same field names.

If any of these user entered data repeats then it should throw an error .

VMname or IPAddress should not be duplicated.

Do guide me what to do.

deepakgarg · ‎10-14-2016

Now, update your script include to:

var CheckVMDuplicate = Class.create();

CheckVMDuplicate.prototype = Object.extendsObject(AbstractAjaxProcessor, {

checkDuplicate : function() {

var s1 = this.getParameter('sysparm_s1');

var s2 = this.getParameter('sysparm_s2');

var s3 = this.getParameter('sysparm_s3');

var gr = new GlideRecord('u_vm_info');//your table name u_vm_info

var gc = gr.addQuery('u_vm1', s1);//Make sure your field names are VM1, VM2, VM3. not titles.

gc.addOrCondition('u_vm2', s1);

gc.addOrCondition('u_vm3', s1);

if(s2 != '') {

gc.addOrCondition('u_vm1', s2);

gc.addOrCondition('u_vm2', s2);

gc.addOrCondition('u_vm3', s2);

}

if(s3 != '') {

gc.addOrCondition('u_vm1', s3);

gc.addOrCondition('u_vm2', s3);

gc.addOrCondition('u_vm3', s3);

}

gr.query();

if(gr.next())

return false;

		gr.initialize();
		gr.u_vm1 = s1;
		gr.u_vm2 = s2;
		gr.u_vm3 = s3;
		gr.insert();

return true;

},

type: 'CheckVMDuplicate'

});

Add these lines, it will insert the values in the table also.

View solution in original post

aastha3 · ‎10-13-2016

I want whatever data is filled on fields of Virtual Machine CI form that should get saved in a custom table .

Also data should not be duplicated . After user enters the data when he'll click submit it should show error if same data is entered again by the user.

Mihir Mohanta · ‎10-13-2016

1.Write a before insert/update business rule that will run on cmdb_ci_vm table.

2.Inside the script glide query to cmdb_ci_vm table to find out with same name and IP address record already present in the table or not for which you are inserting/updating.

If it is present then throw error message like:

gs.addErrorMessage("Duplicate records");

current.setAbortAction(true);

Thanks,

Mihir

aastha3 · ‎10-13-2016

Or should I write Onsubmit client script ?

Mihir Mohanta · ‎10-13-2016

You should write this server sided because if any record inserts / updates via script then also this validation will work.

Thanks,

Mihir