- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 03:15 AM
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 ?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 04:14 AM
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();

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 03:19 AM
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();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 03:22 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 03:37 AM
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();
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2020 03:21 AM
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();