How to query user name

Sironi
Kilo Sage

Hi,

Some one help me in GlideQuery.

var gr= "David Faroon"

var rp = new GlideRecord('resource_plan');
rp.initialize();
var usergr = new GlideRecord('sys_user');
usergr.addQuery('name', gr);
usergr.query();
if (usergr.next()) {
rp.user_resource = usergr.sys_id;
}
rp.insert();

 

is it right way to compare name with User table, if yes then ResourcePlan not created . any suggestions ?

1 ACCEPTED SOLUTION

okay.

So try it like this.

 

var gr = "David   Faroon";
gr = gr.trim().replace(/\s+/g,' ');
var rp = new GlideRecord('resource_plan');
rp.initialize();
var usergr = new GlideRecord('sys_user');
usergr.addQuery('name',gr);
usergr.query();
  if (usergr.next()) {
    gs.info("Entered into your if condition");
    rp.user_resource = usergr.getValue("sys_id");
  }
rp.setWorkflow(false);
rp.insert();

View solution in original post

32 REPLIES 32

Jaspal Singh
Mega Patron
Mega Patron

Hi,

 

Can you try below.

var gr= "David Faroon";
var valueis;
var rp = new GlideRecord('resource_plan');
rp.initialize();
var usergr = new GlideRecord('sys_user');
usergr.addQuery('name', gr);
usergr.query();
if (usergr.next()) {
valueis=usergr.sys_id;
}
rp.user_resource = valueis;
rp.insert();

 

HI,

Just to add on Jaspal's script.

User table can be quite big so ill add Active clause check also to ensure they query is good performance wise.

-Anurag

-Anurag

i m trying from Scheduled Job.

can we use "Contains" because sometimes there may be some space in value of variable 

is it right format ?

 

var gr= "David Faroon"

var usergr = new GlideRecord('sys_user');
usergr.addQuery('name', 'CONTAINS', gr);
usergr.query();
if (usergr.next()) {
var rp = new GlideRecord('resource_plan');
rp.initialize();
rp.user_resource = usergr.getUniqueValue();
rp.insert();
}

asifnoor
Kilo Patron

Hi,

Try this. Also check the logs once.

Seconely is user_resource a reference field?

var gr= "David Faroon";
var rp = new GlideRecord('resource_plan');
rp.initialize();
var usergr = new GlideRecord('sys_user');
usergr.addQuery('name',gr);
usergr.query();
  if (usergr.next()) {
    gs.info("Entered into your if condition");
    rp.user_resource = usergr.getValue("sys_id");
  }
rp.insert();