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.