- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 09:58 AM
Hi All,
I have a workflow where I need to capture the sysid of user from the configured variable "term_user" which is referencing to "sys_user" table. If requester specify the user name then
script should capture the user value & get it's sys id.
Condition: If user is active then it should return true else false.
I have created the below script but it's always returning "no" as value. Can someone have a look & let me know the reason.
----------------------------------------------------------------------
//Script to check whether user is active or not.
answer = ifScript();
function ifScript() {
var t_user = current.variables.term_user.sys_id; //term_user is a variable where user is providing the user information
var user = new GlideRecord('sys_user');
user.addQuery(t_user);
user.query();
while (user.next())
{
if (user.active == true)
{
answer = 'yes';
}
else
{
answer = 'no';
}
}
-----------------------------------------------------------------------------------
Thanks in advance!
Kind regards,
Manish
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2017 10:21 AM
Thanks every one, by the below query I am able to get the proper result in workflow.
var t_user = current.variables.term_user;
var gr = new GlideRecord('sys_user');
gr.addQuery('sys_id', t_user);
gr.query();
if (gr.next())
{
if (gr.active == true)
{
answer = true;
}
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 10:39 AM
Did you try this?
//Script to check whether user is active or not.
answer = ifScript();
function ifScript() {
var t_user = current.variables.term_user.sys_id+''; //term_user is a variable where user is providing the user information
var iuser = new GlideRecord('sys_user');
iuser.addQuery('sys_id',t_user);
iuser.query();
if (iuser.next())
{
if (iuser.active == 'true')
{
return 'yes';
}
else
{
return 'no';
}
}
Please mark this response as correct or helpful if it assisted you with your question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 10:42 AM
Also I hope, this workflow is on sc_req_item table and not on sc_request table
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 10:52 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 10:40 AM
can you please send the screenshot. Want to check once.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-30-2017 10:49 AM