question Re: Insert new record in Developer forum

Insert new record

charanpreet — Fri, 21 Oct 2016 09:24:41 GMT

I am trying to insert a new record to another table.

Issue is the record gets inserted but with the blank values.

var gr = new GlideRecord('asmt_m2m_category_assessment');

gr.initialize();

gr.assessment_record = current.vendor;

gr.category = current.u_it_resource_subtower;

gs.addInfoMessage(gr.assessment_record);

gs.addInfoMessage(gr.category);

gr.insert();

Output : for assessable record : sysid

gr.category : correct value

But the record created in the table does not have any value for any of the two columns.

Re: Insert new record

BALAJI40 — Fri, 21 Oct 2016 09:35:24 GMT

Hi kaur,

May be on that table you do not have read acl. Please check the acl and try.

Re: Insert new record

charanpreet — Fri, 21 Oct 2016 09:58:56 GMT

Hi balaji,

There are ACLs configured for write and create operation with role assessment_admin.

Will this make any difference while creating a new record through business rule.

Re: Insert new record

charanpreet — Fri, 21 Oct 2016 10:01:47 GMT

Also I cannot do any changes in the ACL

Re: Insert new record

Pradeep J — Fri, 21 Oct 2016 10:07:53 GMT

Hi ,

from where you fetching data ? from Catalog or from table?

Re: Insert new record

Deepak Kumar5 — Fri, 21 Oct 2016 10:08:45 GMT

First elevate your role to security admin.

Re: Insert new record

charanpreet — Fri, 21 Oct 2016 10:13:35 GMT

from contract table

Re: Insert new record

BALAJI40 — Fri, 21 Oct 2016 10:14:09 GMT

Hi kaur,

Do you have assessment admin role. In that table write operation for those role only, based on acl only we can access the data.

even try one more,

var gr = new GlideRecord('asmt_m2m_category_assessment');

gr.initialize();

gr.assessment_record = current.vendor;

gr.category = current.u_it_resource_subtower;

gs.addInfoMessage(gr.assessment_record);

gs.addInfoMessage(gr.category);

var sysId= gr.insert();

gs.addInfoMessage('AssignGrp:'+gr.assessment_record+' ,category:'+gr.category+' ,sys_id:'+sysId); // check it shows sys_id or not

if not try to trigger same business rule with, assessment_admin role user by impersonating some one.

please let me know what are all the results do you get.

you mentioned only create and read acl on that table. If there is read acl defined means all users having read access.

Re: Insert new record

charanpreet — Fri, 21 Oct 2016 10:22:45 GMT

Tied the above record,output : Vendor:99ee8bcedb262e00077f7111cf96194bcatEnterprise Data Centersysid7d78b7dadba26e00077f7111cf961933

Re: Insert new record

BALAJI40 — Fri, 21 Oct 2016 10:30:18 GMT

Do you have this role "assessment_admin"?

Re: Insert new record

charanpreet — Fri, 21 Oct 2016 10:45:30 GMT

I have admin role

Re: Insert new record

BALAJI40 — Fri, 21 Oct 2016 10:50:11 GMT

if you have admin role and you have access to see all the data.

is there already data present in the table or empty?

Re: Insert new record

Deepak Kumar5 — Fri, 21 Oct 2016 11:05:24 GMT

What is the field type of the assessment and category?

try with

gr.assessment_record = current.vendor.getDisplayValue();

gr.category = current.u_it_resource_subtower.getDisplayValue();

Re: Insert new record

charanpreet — Sun, 23 Oct 2016 11:49:35 GMT

I used getDisplayValue() and setDisplayValue and it worked.

Re: Insert new record

Deepak Kumar5 — Sun, 23 Oct 2016 12:09:21 GMT

Please mark my response as correct so that it gets removed from unanswered list and will help others to find the answer quickly.

If you are viewing this from the community inbox you will not see the correct answer button. You need to open the thread directly and you will see a correct answer button with red star. Please review this How To Mark Answers Correct From Community Inbox