Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2016 12:12 AM
var sysID = current.sys_id.toString();
var reqTask = new GlideRecord('u_request_tasks_definition');
reqTask.addQuery('u_order', '>', workflow.scratchpad.currentOrder);
reqTask.addQuery('sys_id', sysID);
gs.log("SYS ID OF U ASSIGN is: " + reqTask.sys_id +" SYS ID OF CURRENT IS" + sysID);
reqTask.orderBy('u_order');
reqTask.query();
The table is u_request_tasks_definition. it contains a reference field named u_accociated_item that take a vlue from the sc_cat_item table. I want to fetch the ID of the sc_cat_item that is referenced in the u_accociated_item column.