scratchpad values into a glide query to create a new group based on variables in requested item

[levino]

Hi Team

in run script activity which is a part of a workflow, the below does not seem to work, am i missing something?

Thanks

Levino

workflow.scratchpad.Description = current.variables.description;
workflow.scratchpad.NewGroupName = current.variables.new_group_name;

var gr = new GlideRecord('sys_user_group'); //To create group


gr.initialize();

gr.name = workflow.scratchpad.NewGroupName;
gr.type = 'a23a29e8dbec8850304c147a3a96191f';
gr.description = workflow.scratchpad.Description;


gr.setWorkflow(false);
gr.autoSysFields(false);
gr.sys_updated_by = 'admin_sp';
gr.sys_created_by = 'admin_sp';
gr.company = 'd9057fc1db98d7005070326f7c961926';
var grSysid = gr.insert();

[levino]

Hi Tai

no error message is showing

[Ankur Bawiskar]

@levino 

script looks good to me.

ensure you use correct field names etc

what debugging have you done so far?

[levino]

Hi Ankur

yes i am using the correct field names.

pleas advise what debugging i need to do

[Ankur Bawiskar]

@levino 

try to add gs.info() and debug

[Danish Bhairag2]

Hi @levino ,

As mentioned by aniket there is no field for company in Group table ,hence it is failing. If u intend to populate vendor field in group table then use gr.vendors instead of gr.company.

Attaching the screenshot of available fields in group table.

Thanks,

Danish